Reply
Highlighted
Member
Posts: 81
Registered: ‎10-29-2015
Accepted Solution

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  


Accepted Solutions
Super User
Posts: 2,146
Registered: ‎08-11-2015

Re: Is it possible Power BI is calculating incorrectly?

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

 

View solution in original post

New Contributor
Posts: 545
Registered: ‎10-27-2015

Re: Is it possible Power BI is calculating incorrectly?

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

View solution in original post

Established Member
Posts: 196
Registered: ‎09-30-2015

Re: Is it possible Power BI is calculating incorrectly?

Super User
Posts: 2,146
Registered: ‎08-11-2015

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

View solution in original post


All Replies
Super User
Posts: 2,146
Registered: ‎08-11-2015

Re: Is it possible Power BI is calculating incorrectly?

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

 

New Contributor
Posts: 545
Registered: ‎10-27-2015

Re: Is it possible Power BI is calculating incorrectly?

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

Established Member
Posts: 196
Registered: ‎09-30-2015

Re: Is it possible Power BI is calculating incorrectly?

Well spotted @Sean 😂
Super User
Posts: 2,146
Registered: ‎08-11-2015

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

Member
Posts: 81
Registered: ‎10-29-2015

Re: Is it possible Power BI is calculating incorrectly?

Oh gosh! Thanks gentlemen. Thoroughly embarrased Smiley LOL