Removing Duplicate Items and plus its quantity

[shabirAhmad]

Hi Experts,

I want to remove duplicate from my table how can i? As shown in below image  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

Best Regards,

Shabir Ahmad

[HarishKM]

@shabirAhmad  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.

exam 2 - I have not put date in row context so now I am getting monthly sales number instead of daily.

 Thanks

Harish M

If it is fulfilling your requirement then Kindly select it as a solution and Kindly give Kudos any way.

[danextian]

Hi @shabirAhmad 

To remove duplicates while aggregating the rows, you can use the Group By feature in Power Query:

[shabirAhmad]

Hi @danextian ,

Thanks for your reply, i followed you suggestion but it hide remaing columns .

Best Regards,

Shabir Ahmad

[danextian]

Please see below:

[Idrissshatila]

Hello @shabirAhmad ,

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.

so if you have more that are in the screenshot just add them.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡