% Change number not calculated correctly, maybe rounding?

[nleuck_101]

Hello All,

I could use some help with calculating Month over Month % change. Below are my formulas I'm using and results I'm getting. Any help would be greatly appreciated!

Measure 1 (1st column total) = SUM(Table[Column])
Measure 2 (2nd column total) = CALCULATE(Measure 1, PREVIOUSMONTH(DateTable[date_field]))

Measure 3 (3rd column total) = DIVIDE(Measure 1 - Measure 2, Measure 2, 0)

Example October 2022: (756-697) / 697 --> 59 / 697 --> 8.46% but in Power BI I get 8.32%

[HotChilli · Accepted solution]

Looks like you will have to ROUND the measures when you use them in measure3

[nleuck_101]

@HotChilli 

Yes, it looks like a rounding issue. How can I get around this using whole numbers?

[HotChilli]

8.32% is 58 (more or less) so yes, I suspect that the real figures are not 756 or 697 exactly.  There will be decimals in there which are not shown in the display but will be used in the measure formula.

That's my theory.  You can prove it by formatting the measures to show a few decimal places.