Forum Discussion
Solved
Measuring Average Delta
Hey everyone, I'm having an unusual issue with calculating an average difference. Basically, my goal is to calculate the 2 month average difference of the current year and last year of the lengt...
Additional notes:
So (182 - 179)/179 = 1.68%
Power BI is calculating 1.29%. So .5% off was a little aggressive, my apologies.
Issue resolved, there isn't actually an issue either. I'm presenting my raw column as an "Average of LOS" and my calcuation is more accurate. Power BI is doing exactly what it's told and accurately but within two different contexts in which my report is not accouting for in the presentation. So both are right at the same time. My user will have to decide how the report will be presented in a way that will make sense.
Best Regards
Maggie