Conditional Column, Index Column And Duplicate Column In Power BI

Alternatively you can also delete the column by right clicking and choosing the Remove option as in below image.

Index Column

Create a new column with an index starting at 0.

Adding Index Column

Click on Add Column – Index Column will by default create the column with name Index and value with starting 0 and increment each value by 1 with the previous values.

You can create the starting index with 1 after selecting the From 1 option of Index column as below.



Adding Custom index Column

You can create your own custom index column by selecting the custom option of Index column dropdown as shown in above image. Once you click on Custom a new window as below opens for providing the starting index and increment value.

Now click on OK you will get the Index column as below

Editing or Deleting the Index Column

You can edit or delete the Index column with the same step as you have followed to edit and delete the conditional column. Just you have to click on setting option of added step for editing and delete or cross option for deleting the Index column. An added step is as below.

Duplicate Column

Create a new column that duplicates the values in the currently selected column.

Creating or Adding Duplicate Column

For adding Duplicate column first select the column for which you want to create a duplicate or copy then click on Duplicate Column option of Add Column tab.

Add Column – Duplicate column

Editing or Duplicating Column

For this you can follow the same step as you have followed for editing and deleting the conditional column or index column

Summary

In this article we have learned about the three important columns category conditional column, index column and duplicate column in Power BI. We have learned the definition and how to create, edit or delete these columns? All these options are available in query editor window Add Column tab.