Скачать или смотреть Master in Excel Power Query | Aggregations | Sum, Count, Average, Min, Max Group By

Welcome to RPA Master – 🔹 What are Aggregations in Power Query?

Aggregations in Power Query help you summarize data by performing calculations like Sum, Count, Average, Min, Max etc.
This is useful when you want to analyze large datasets by grouping or summarizing values.

🔹 Common Aggregations in Power Query

Sum – Add values in a column

Table.Group(Source, {"Category"}, {{"Total Sales", each List.Sum([Sales]), type number}})


Count – Count rows or values

Table.Group(Source, {"Category"}, {{"Row Count", each Table.RowCount(_), Int64.Type}})


Average – Find mean of values

Table.Group(Source, {"Category"}, {{"Average Sales", each List.Average([Sales]), type number}})


Minimum (Min) – Get smallest value

Table.Group(Source, {"Category"}, {{"Min Sales", each List.Min([Sales]), type number}})


Maximum (Max) – Get largest value

Table.Group(Source, {"Category"}, {{"Max Sales", each List.Max([Sales]), type number}})

🔹 Steps to Perform Aggregations in Power Query

Load your data into Power Query

Select the column(s) you want to group by

Go to Home → Group By

Choose the aggregation (Sum, Count, Average, Min, Max)

Click OK to apply

🔹 Real-Life Example

If you have a Sales Table with Category and Sales,
👉 Group By Category → Apply Sum of Sales
This gives Total Sales per Category.