keep_bottom_rows
Keep only the last N rows in a Power Query table by appending Table.LastN to the M query. Specify session, table, and count to preserve bottom rows.
Instructions
Power Query Keep Bottom Rows: keep only the last N rows. Appends Table.LastN to the table's M query.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| count | Yes | number of rows to keep from the bottom | |
| table | Yes | ||
| sessionId | Yes | ||
| partitionName | No | partition name (optional; defaults to the first partition) |