Forum Discussion
Correlation coefficient between a measure and date using DAX
Hello,
I need to calculate the correlation coefficient between a measure price (y) and date (X) using DAX.
Please advise and if possible provide the DAX.
3 Replies
You can't use dates. Both values must be numeric. Which correlation do you want to compute? Pearson?
Correlation Coefficient in Power BI using DAX - Ben's Blog (datakuity.com)
Thanks for the article. Yes, need to do a Pearson correlation coefficient between a value and date. This should be possible, correct?
https://towardsdatascience.com/four-ways-to-quantify-synchrony-between-time-series-data-b99136c4a9c9
Should I convert date to unix timestamp would that work with the concept in your article?
yes, an epoch value would work.
