Microsoft Power BI Cookbook

Residuals table and measures

1. From the modeling tab, click New Table and create a Residuals table:

Residuals = VAR Intercept = [MktSales Intercept]VAR Slope = [MktSalesSlope]ReturnADDCOLUMNS(MktSalesRegression,"Y Intercept",Intercept,"Slope",Slope,    "Predicted Internet Sales", ([Marketing Amount]*Slope) + Intercept,    "Residual",[Internet Sales] - (([Marketing Amount]*Slope) + Intercept))

• The regression table and measures created earlier are referenced to support analysis of the model

The Residuals table created via

DAX variables are used to store the computed values of the Slope and intercept measures, such that the same values (47 and 34,447, ...