Removing Duplicate Items and plus its quantity

Question

Hi Experts,I want to remove duplicate from my table how can i? As shown in below image&nbsp; Item Number 00000056 in in 2 rows how to make it in one row and plus it quantity if there is quantity in different rows&nbsp;&nbsp;Best Regards,Shabir Ahmad

danextian · Answer

Hi&nbsp;shabirAhmad&nbsp;
To remove duplicates while aggregating the rows, you can use the Group By feature in Power Query:

&nbsp;
&nbsp;

idrissshatila · Answer

Hello&nbsp;shabirAhmad&nbsp;,&nbsp;so in your case you click on afvanced and add the columns that you want to aggregate down and the ones that you want to group by to up.&nbsp;so if you have more that are in the screenshot just add them.&nbsp;&nbsp;&nbsp;If I answered your question, please mark my post as solution, Appreciate your Kudos&nbsp;👍Follow me on LinkedinVote For my Idea💡&nbsp;

danextian · Answer

Please see below:

&nbsp;

harishkm · Answer

shabirAhmad&nbsp; Hello Sabir,Kindly check your table , There must be date or any dimension column is diff.I will suggest that, You can use the post value column as measure in table visual then drag the respective dimension to get the result or you can use group by funcnality of power query.like exam 1 - it contain total sales by date instead of month.&nbsp;exam 2 - I have not put date in row context so now I am getting monthly sales number instead of daily.&nbsp;&nbsp;&nbsp;&nbsp;ThanksHarish M&nbsp;If it is fulfilling your requirement then Kindly select it as a solution and Kindly give Kudos any way.&nbsp;

shabirahmad · Answer

Hi&nbsp;danextian&nbsp;,&nbsp;Thanks for your reply, i followed you suggestion but it hide remaing columns .&nbsp;Best Regards,Shabir Ahmad

Forum Discussion

Related content

remove duplicate value within a row

Removing Duplicates

How to stop PowerBI from automatically removing duplicates.

Removing duplicates

Remove duplicates bug