cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cwayne758 Member
Member

Is it possible Power BI is calculating incorrectly?

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). 

 

potentialerror.PNGCol 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  

4 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Is it possible Power BI is calculating incorrectly?

There's no mistake if you substract the 2 numbers in the Visual Total.

 

greggyb New Contributor
New Contributor

Re: Is it possible Power BI is calculating incorrectly?

I'm fairly certain that's the correct number. What are you double checking on?

itchyeyeballs Established Member
Established Member

Re: Is it possible Power BI is calculating incorrectly?

Well spotted @Sean 😂
Super User
Super User

Re: Is it possible Power BI is calculating incorrectly?

$464,665.79 in the Visual

 

$464,655.79 in your calculation

 

Here's your missing 10

5 REPLIES 5
Super User
Super User

Re: Is it possible Power BI is calculating incorrectly?

There's no mistake if you substract the 2 numbers in the Visual Total.

 

greggyb New Contributor
New Contributor

Re: Is it possible Power BI is calculating incorrectly?

I'm fairly certain that's the correct number. What are you double checking on?

itchyeyeballs Established Member
Established Member

Re: Is it possible Power BI is calculating incorrectly?

Well spotted @Sean 😂
Super User
Super User

Re: Is it possible Power BI is calculating incorrectly?

$464,665.79 in the Visual

 

$464,655.79 in your calculation

 

Here's your missing 10

Highlighted
cwayne758 Member
Member

Re: Is it possible Power BI is calculating incorrectly?

Oh gosh! Thanks gentlemen. Thoroughly embarrased Smiley LOL