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

Hi ZD,

 

thanks for reply. I couldn't upload a sample file, basically I have a column of prodcut and one column of customer, column of month of sales, then another column of sales in units.

 

what I try to do is to work out a way to calculate correlation coefficient for one customer between all products with certain period of historical sales. 

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.