Forum Discussion
Resolver IICorrelation Coefficient Calculation for time period
I am new to DAX. I am looking for correlation coeffient calculation that calculates the last 60 days. This should be a calculated column.
I appreciate any help.
Thank you
rschaudhr , you need control of your measure or data for 60. You can use relative date slicer for that
You can refer this blog for Correlation-coefficient
https://community.powerbi.com/t5/Quick-Measures-Gallery/Correlation-coefficient/td-p/196274
2 Replies
- Greg_Deckler
Community Champion
rschaudhr There is a built in Quick Measure for correlation coefficient. You could steal code from there. If you want to account for seasonality, then you could steal code from here:
Otherwise, need more info.
- amitchandak
Super User
rschaudhr , you need control of your measure or data for 60. You can use relative date slicer for that
You can refer this blog for Correlation-coefficient
https://community.powerbi.com/t5/Quick-Measures-Gallery/Correlation-coefficient/td-p/196274
