GroupBy — Power Fx function reference

Syntax

GroupBy( Table, Column1 [, Column2, ... ], GroupColumnName )

Examples

GroupBy(Sales, "Region", "Rows")

GroupBy(Sales, "Region", "ByRegion")

AddColumns(GroupBy(Orders, "CustomerID", "CustomerOrders"), "OrderCount", CountRows(CustomerOrders))

Common mistakes & gotchas

• The final argument names a new column holding a nested table of each group's rows — GroupBy alone does not aggregate; pair it with AddColumns plus Sum/CountRows on the nested table for per-group totals.
• GroupBy is not delegable on most connectors, so grouping a large tabular source only groups the rows already retrieved locally.

Related Power Fx functions

From Table shaping

Used in these tutorials