Index column in Power BI

In Power Query Editor, we can create an Index Column in the table.

The Index column command adds a new column to the table with explicit position values, and is usually created to support other transformation patterns.

Select the table from the Queries pane in which we want to add the index column, then from the Add column menu at the top, select the Index Column option.

By default, the starting index will start from the value 0 and have an increment of 1 per row.

We can also configure the behavior of this step by selecting the Custom.. option and configuring two parameters:
• Starting index: It specifies the initial index value.
• Increment: It specifies how much to increment each index value.

Let’s specify the Starting index as 4 and Increment as 2, as shown in the image below:s

We can see the index column is created in the table. We can add multiple index columns in the table.