Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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?