Forum Discussion
1 column data correclatio coefficient
Hi cyuan
You can get this result by using the pivot column in Power Query:
Here are steps:
First of all, Select the Product column and click the Pivot column in the Transform pane:
The result is as follow:
But I can't understand how to get the 2%, 24% and -34%, if possible please share the logic of these results.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks ZD for prompt reply.
the % is calculated in Excel with forumla Correl(array1, array2)
I try to use the dax quick measure correlation coeffecient however it ask for 2 columns, in this case it does't really help because i will have more than 2 columns.
thanks
)
IrwanSuper User
Hello cyuan
Not sure if this match to your need but please have a look.
That was my post and answered by @lbendlin. The DAX works perfectly.
Thank you.
thanks Irwan, not precisely, @Ibendlin DAX is autocorrelation and it is a tool to look at correlation for one variable but different lag, it should eventually return to 0. What I am after is 1 v 1 correlation based but multiple comparison.
thanks anyway,.