Correlation coefficient between a measure and date using DAX

[Williamson1]

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.

[lbendlin]

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)

[Williamson1]

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?

[lbendlin]

yes, an epoch value would work.