R squared as measure in Excel Power Pivot

Question

Is there a simple way to caclulate the R^2 value in a Power Pivot? In 'normal' excel, we can use the RSQ function but that function doesn't exist among the Measure functions in Power Pivot.

Answer 1

Short answer: No. There's no native DAX equivalent of the Excel RSQ function.

You could create DAX calculations to determine the Pearson correlation (example) or you could use R script (example)