sort_rows
Sort rows in a Power BI table by one or more columns with optional ascending or descending direction, appending Table.Sort to the M query.
Instructions
Power Query Sort Rows: sort by one or more columns. Appends Table.Sort to the table's M query. sorts is comma-separated as column[:direction], e.g. "Region:Ascending,Sales:Descending". direction = Ascending | Descending (default Ascending).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sorts | Yes | sort keys as column[:direction], comma-separated | |
| table | Yes | ||
| sessionId | Yes | ||
| partitionName | No | partition name (optional; defaults to the first partition) |