add_index_column
Add a sequential index column to your Power Query table by appending Table.AddIndexColumn to the M query. Specify column name, start value, and step increment directly.
Instructions
Power Query Add Index Column: add a sequential index. Appends Table.AddIndexColumn to the table's M query.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | No | the index column name (default Index) | |
| step | No | increment between rows (default 1) | |
| start | No | starting value (default 0) | |
| table | Yes | ||
| sessionId | Yes | ||
| partitionName | No | partition name (optional; defaults to the first partition) |