Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Different totals than in data source

Hi all.  My data set in Excel shows the total sales for the years 2013 - 2020 to be 6,107,910 but PBI is showing me 6,107,925.  What I did, to double-check, I basically just uploaded to PBI a mock ...
Need Help
  • Ajinkya369's avatar
    Ajinkya369
    6 years ago

    Hey Anonymous ,

     

    Click on Transform DataTransform Data

     

    Then Select the amount column ->right Click -> Change data type -> Decimal Number

     

    Change type

     

     

    This is your Row card with correct output:

     

    Output

    If your problem is solved then accept this as solution

     

    Thank you

     

Arklur's avatar
Arklur
Resolver II
6 years ago

The data type of the `AMOUNT` column is set to "Whole Number" in the Power Query editor. Switch it "Decimal Number" and PBI will show "...910" too.