Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I am unable to get the right value of correlation analysis when I analyze the data at month level. I have a data set that contains cases reported for 7 years. There are two different type cases category:
1. Good AFP cases
2. Normal
When I calcualte correlation of good AFP cases using a formula given in the attached file, it calcualtes it right at year interval. However, the value is not right for monthly interval at district level.
I am attaching the files as well. Would be very really thankful if anyone can sort it out.
Excel file (correlation is also calcuated)
POWER BI file (correlation calcuated that is not coming correct)
@Mughees Have you looked at these?
Correlation coefficient - Microsoft Power BI Community
De-Seasonalized Correlation Coefficient - Microsoft Power BI Community
Hi Greg
Yes, I have applied similar formula. The issue is that when I calculate correlation btw year and cases, the value is fine. However, when I apply the same formula for year-month and cases, the value is not coming right.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |