Forum Discussion

cyuan's avatar
cyuan
Frequent Visitor
2 years ago

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...
cyuan's avatar
cyuan
Frequent Visitor
2 years ago

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

 

 

)

  • cyuan's avatar
    cyuan
    Frequent Visitor
    2 years ago

    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,.