SUM Aggregation doubling the values

[amansinghfirstb]

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. 

[Fowmy]

@amansinghfirstb 

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 🙂

YouTube  LinkedIn

[amansinghfirstb]

@Fowmy But my data columns are already whole number type! 

[Fowmy]

@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 🙂

YouTube  LinkedIn

[amansinghfirstb]

@Fowmy  Sorry but it didn't change this bug. Let me know if you need anymore information.

[Fowmy]

@amansinghfirstb 

Not clear ,

Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

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

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

YouTube, LinkedIn

[amansinghfirstb]

So, the column Miss = Order_Qty - Qty_Shipped

The problem is that I can't share the pbix file as it's confidential and cleaning the requisite keys would just kill the whole thing.

[htaquee]

did you find a solution? i am having same problem. where new column Total = 1+1 return turns out to be 4 instead of 2. I am not sure why is that happening.