Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
User | Count |
---|---|
77 | |
74 | |
42 | |
32 | |
28 |
User | Count |
---|---|
99 | |
92 | |
50 | |
49 | |
46 |