Forum Discussion
cyuan
2 years agoFrequent Visitor
1 column data correclatio coefficient
Hi all, i would like to measure the correlation between different SKUs with sales history. i have attached the sample data, they are all in one table. can you please help? CY Produc...
Irwan
Super User
2 years agoHello 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.
cyuan
2 years agoFrequent Visitor
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,.