SOLVED

Power Query Group By

Contributor

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 Area) and the counts. So I want it to read:

9/20/2022    AGUILAH    Tugger    395

9/20/2022   AVILA, Efrain   1st Floor Mezz   594

Etc...

image001 (7).png

 

Thank you in advance!

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@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