You’re offline. This is a read only version of the page.
Announcements
31
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!
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
Share
Report
All responses (
Answers (
