Forum Discussion
Helper IPearson Coefficient correlation for Performance trend
Dimitri70 - Have you tried the measure mentioned in this blog?
https://xxlbi.com/blog/pearson-correlation-coefficient-in-dax/
It's from a very skilled Microsoft MVP.
Hopefully this helps you achieve the answer you are looking for.
If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!
Community SupportHi Dimitri70.,
Thank you for bringing up this question.
I would like to reinforce the valuable recommendation shared by mark_endicott . The referenced blog provides a clear explanation and a practical DAX implementation of the Pearson correlation coefficient, which is highly effective for analyzing trends such as the negative pattern in your on-time rate.
Using this method allows you to statistically measure the correlation between time (month index) and your performance metric (on-time rate), supporting clearer visualization and communication of delivery performance trends within your dashboard.
A value near -1 indicates a strong negative correlation, which aligns with your observations.
I hope this helped! Feel free to ask any further questions. If this resolved your issue, please mark it as "Accept as Solution" and give us Kudos to assist others.
Thank you and Continue using Microsoft Fabric Communtiy Forum.