Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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%
Solved! Go to Solution.
Looks like you will have to ROUND the measures when you use them in measure3
Looks like you will have to ROUND the measures when you use them in measure3
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.
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |