Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Consolidate Rows Aggregating some columns and keeping the first record for another column

I have multiple rows of data that I need to consolidate into one row.  Some columns are aggregated (Sum) and ONE column has different values but I need to maintain ONLY the first value.    My data ...
Need Help
  • olgad's avatar
    olgad
    3 years ago

    Hi there,

    you can try getting what you want in Power Query, 
    Transform-Group By-Advanced- for the name pick Max/Min as aggregation, for the amount-sum.

    Once done, go to M-Code and change Max/Min to the First. 

    and there you have it.

    Hope that helps. 

     

olgad's avatar
olgad
Resident Rockstar
3 years ago

Hi there,

you can try getting what you want in Power Query, 
Transform-Group By-Advanced- for the name pick Max/Min as aggregation, for the amount-sum.

Once done, go to M-Code and change Max/Min to the First. 

and there you have it.

Hope that helps. 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

olgad THANK YOU SO MUCH!!  It worked PERFECTLY!!