Forum Discussion
SUM Aggregation doubling the values
Hi,
I am seeing a new bug in the pbix file. The values during the sum/difference aggregation is doubling. I have appended the file through many different excel files representing different business unit functions.
7 Replies
This could happen if your data has spaces, to remove, trim the data column in Power Query
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy But my data columns are already whole number type!
amansinghfirstb
I meant the #Item column, I can see them as duplicated .________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
