Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
So I've been fiddling with some figures and doing a bit of validation, when I came across a discrepency that I haven't been able to identify the root cause of it.
Is it possible Power BI is somehow incorrectly calculating my data? (Unlikely, I know).
Col 1: Month Col2: This year figures Col3: Last Year figures Col4: YOY Figures
464,655.79 minus 2,912,595.64 = (2,447,939.85)
I have been unable to explain why my PowerBI Table visual is giving me 10 less than the correct arthimentic.
Thanks in advance
Solved! Go to Solution.
There's no mistake if you substract the 2 numbers in the Visual Total.
I'm fairly certain that's the correct number. What are you double checking on?
$464,665.79 in the Visual
$464,655.79 in your calculation
Here's your missing 10
$464,665.79 in the Visual
$464,655.79 in your calculation
Here's your missing 10
Oh gosh! Thanks gentlemen. Thoroughly embarrased
There's no mistake if you substract the 2 numbers in the Visual Total.
I'm fairly certain that's the correct number. What are you double checking on?