Sum column when removing duplicates

[Dhjlm]

Here's an example of my problem.

I have a table that look like this:

I would like to sum column 2 when I'm removing duplicates in column 1.

So the final result will be this:

Is there a easy way to fix this problem?

[AlB · Accepted solution]

Hi @Dhjlm 

Just use the Group By feature in Power Query with Sum as operation

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[amitchandak · Accepted solution]

@Dhjlm , if you need a new table

summarize(Table, Table[column1], "Column2",sum(Table[Column2]))

or use measure sum(Table[Column2]) in visual with  column1

[AlB · Accepted solution]

Hi @Dhjlm 

Just use the Group By feature in Power Query with Sum as operation

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers