Forum Discussion
Using the two columns of data with the highest correlation in/for other calculations.
Is there a way that I can: Have 5 sets of 2 columns. (Separate tables or not, doesn't matter) Calculate the R value for each pair of columns. Automatically find which is the highest R value and us...
daXtreme
Solution Sage
Solution SageIf you don't get answers for a long time... it means your question is not clear. Since you're a new member, please familiarize yourself with this first: How to Get Your Question Answered Quickly - Microsoft Power BI Community
And then rephrase your question to be understandable. Thanks.
Thanks, I did read this beforehand, I have tried to rephrase, unfortunately I am struggling with the explanation and have no other data or formulas to provide.
I can calculate all of this in excel quite easily but need it to be dynamic in Power bi as the columns of data can change. Hopefully my rewording is better.
