The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?