filter_rows
Keep only rows that meet a condition in Power Query M by appending a Table.SelectRows step. Specify conditions like [Amount] > 0 to filter your table.
Instructions
Power Query Filter Rows: keep only the rows matching a condition. Appends Table.SelectRows(prev, each ) to the table's M query. Provide the condition referencing the row as _, e.g. "[Amount] > 0 and [Region] = "NZ"" (the 'each' is added if you omit it).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| sessionId | Yes | ||
| mCondition | Yes | the row condition, e.g. [Amount] > 0 | |
| partitionName | No | partition name (optional; defaults to the first partition) |