Forum Discussion
Helper IIRemoving Duplicate Items and plus its quantity
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
5 Replies
- danextian
Super User
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
- 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đź’ˇ
- 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.
