Forum Discussion

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 of my original data set with only total sales for 2013 - 2020 years and nothing else, and the error keeps showing... Please, help!

Excel

PBI

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

5 Replies

Ajinkya369
Resolver III
6 years ago
Hey Anonymous ,

Can you share the sample data and the pbix file?
and the Dax formula which you used for calculating the total sales.

Thank you.
- Anonymous
  Not applicable
  6 years ago
  PBIX
  https://amksavonia-my.sharepoint.com/:u:/g/personal/karen_urbanocuellar_edu_savonia_fi/EWZmIWzrAFpIn2oX62FZGe8ByIwKaPAfXRV_dvnoEEvScw?e=DHtGtk
  
  SOURCE
  https://amksavonia-my.sharepoint.com/:x:/g/personal/karen_urbanocuellar_edu_savonia_fi/EcHzZ2L51hBKoOI8LWhYWiABkFplS1pqRJAK_WgQfIe7yA?e=3v5dR8
  
  I mean is literally just the amounts, why it can't show the right total? Thanks
  - 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.

Related content