remove_alternate_rows
Remove alternate rows from Power BI tables by specifying starting kept rows and a take/skip cycle, appended to the M query.
Instructions
Power Query Remove Alternate Rows: keep the first firstKept rows, then repeatedly take and skip in a pattern. Appends Table.AlternateRows to the table's M query.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| taken | Yes | rows taken (removed) in each cycle | |
| skipped | Yes | rows skipped (kept) in each cycle | |
| firstKept | Yes | rows kept at the start before the pattern begins | |
| sessionId | Yes | ||
| partitionName | No | partition name (optional; defaults to the first partition) |