Forum Discussion

Helper V

6 years ago

Solved

Duplicate values

Hi,

I have duplicate values in my data.
I need SUM Delivery quantity (e.g. ID 310313809 = 23,80) and then delete duplicate values in column A.

How do I do it in Power Query?

Thank you
Ondřej

Data Protection

Tips and Tricks

FarhanAhmed
6 years ago
Use Group By in Power Query
https://support.microsoft.com/en-us/office/group-rows-in-a-table-power-query-e1b9e916-6fcc-40bf-a6e8-ef928240adf1
amitchandak
6 years ago
Fidzi8 , refer

https://www.poweredsolutions.co/2019/07/30/grouping-rows-with-power-bi-power-query/

2 Replies

FarhanAhmed
Community Champion
6 years ago
Use Group By in Power Query
https://support.microsoft.com/en-us/office/group-rows-in-a-table-power-query-e1b9e916-6fcc-40bf-a6e8-ef928240adf1
amitchandak
Super User
6 years ago
Fidzi8 , refer

https://www.poweredsolutions.co/2019/07/30/grouping-rows-with-power-bi-power-query/

Related content