Forum Discussion
Solved
Power Query Group By
Hi All, New and loving PQ so far. What criteria do I need to tell power query to consolidate the rows. All dates are the same but you can see that each user has multiple rows for their PAr (Pick Are...
Bahama85 Remove Count from the Group By section. In the Aggregation section, set the new column name to Sum, set the Operation to Sum rows and in the last field select column Count to be summed.
Bahama85 Remove Count from the Group By section. In the Aggregation section, set the new column name to Sum, set the Operation to Sum rows and in the last field select column Count to be summed.
- That's perfect! Thank you
