group_by
Aggregate rows by key columns with sum, count, average, min, max, or distinct count. Appends a Table.Group step to the Power Query M code for summarization.
Instructions
Power Query Group By: collapse rows to one per key-column combination with aggregates. Appends Table.Group to the table's M query. keyColumns is comma-separated. aggregations is comma-separated as name:op[:column], e.g. "Total:Sum:Amount,Lines:Count,Distinct Customers:CountDistinct:CustomerId". op = Sum | Count | Average | Min | Max | CountDistinct | All (column required except for Count/All).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| sessionId | Yes | ||
| keyColumns | Yes | the grouping key columns, comma-separated | |
| aggregations | Yes | aggregations as name:op[:column], comma-separated | |
| partitionName | No | partition name (optional; defaults to the first partition) |