Forum Discussion

cwayne758's avatar
cwayne758
Icon for Helper IV rankHelper IV
10 years ago
Solved

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

 

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  

Need Help
  • Sean's avatar
    Sean
    10 years ago

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

     

  • greggyb's avatar
    greggyb
    10 years ago

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

  • Sean's avatar
    Sean
    10 years ago

    $464,665.79 in the Visual

     

    $464,655.79 in your calculation

     

    Here's your missing 10

5 Replies

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

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

     

    • greggyb's avatar
      greggyb
      Icon for Resident Rockstar rankResident Rockstar
      10 years ago

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

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

    $464,665.79 in the Visual

     

    $464,655.79 in your calculation

     

    Here's your missing 10

    • cwayne758's avatar
      cwayne758
      Icon for Helper IV rankHelper IV
      10 years ago

      Oh gosh! Thanks gentlemen. Thoroughly embarrased :smileylol: