Forum Discussion
rschaudhr
Resolver II
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
Greg_Deckler
Community Champion
Community Championrschaudhr 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.