Daniil
Kudo Kingpin
Kudo KingpinCorrelation coefficient
The quick measure calculates the Pearson correlation coefficient between two measures within the category.
NAME:
Correlation coefficient
DESCRIPTION:
Calculate the Pearson correlation...
Sorry to revive an old thread, but I was wondering what the differences were in the DAX Linest and Linestx in calculating the coefficient of detemination. I was using the square for the Pearson coefficient to get R squared. It appears that I am getting different coefficient values between the two functions. I checked in excel and also was getting the same values as the Linest function. Would you happen to know if there are approximations in the Linest function vs your Pearson coefficient?
lbendlin
Super User
Super UserCan't see a reason for that, but is likely a question for jeffrey_wang