Forum Discussion
Different totals than in data source
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
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.
PBIX
SOURCE
I mean is literally just the amounts, why it can't show the right total? Thanks
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.
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 🙂
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
