Forum Discussion

Dhjlm's avatar
Dhjlm
Frequent Visitor
5 years ago
Solved

Sum column when removing duplicates

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?

 

 

Need Help
  • AlB's avatar
    AlB
    5 years ago

    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's avatar
    amitchandak
    5 years ago

    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

2 Replies

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    5 years ago

    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's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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