Different totals than in data source

[Anonymous]

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]

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]

PBIX

https://amksavonia-my.sharepoint.com/:u:/g/personal/karen_urbanocuellar_edu_savonia_fi/EWZmIWzrAFpIn...

SOURCE

https://amksavonia-my.sharepoint.com/:x:/g/personal/karen_urbanocuellar_edu_savonia_fi/EcHzZ2L51hBKo...

I mean is literally just the amounts, why it can't show the right total? Thanks

[Ajinkya369 · Accepted solution]

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

[Fowmy]

@Anonymous 

You need to change the Data Type to Decimal or Fixed Decimal, currently its Whole number in order to match with your Excel file.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[Arklur]

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.