- The created DAX measures correspond to the CORREL(), INTERCEPT(), AND SLOPE() functions in Microsoft Excel:
Correlation Coefficient for a Sample (Pearson's Correlation Coefficient)
Slope of the Regression Line
Intercept of the Regression Line
- The same results from the DAX measures can also be retrieved via Excel formulas
Applying CORREL(), SLOPE(), and INTERCEPT() lines in Excel 2016
- Simply add the regression table ...