How to aggregate rows

(0) Share

Report

Posted on by dthorn1981

Hi!

I am new to Power Query and I am trying to aggregate the following rows by adding a custom column that will sum my data by Direct Expense and Agency Client TP while keeping all the rows and columns in the data. The Agency Client TP is not unique and I need to find all Direct Expenses associated with that column while keeping the other columns of data. Can someone please let me know the best formula to do that or if I should be grouping instead? Thank you!

All responses (1)

Answers (0)

dthorn1981 31 on at

Like (0)

Report

Re: How to aggregate rows

Thank you @Syndicate_Admin for your help. When I applied the first grouping and tried to aggregate, I do not see where I can keep all rows? I only have those two columns when I do that