Power Query Group By

[Bahama85]

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...

Thank you in advance!

[#2 · Accepted 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.

[#3]

That's perfect! Thank you