Creating an index column for Power Bi

6
votes

I have a table of member IDs and transactions in Power BI, I would like to create an index column for it, any suggestions?

Regards

1
powerbi
If your table contains a column of (presumably unique) IDs, why do you need to add an extra index column? It might help to expand your question with sample data and desired results. How to create a Minimal, Complete, and Verifiable example – Joe Gravelyn

1 Answers

22
votes

My preferred method is to use PowerQuery (Power BI's Query Editor). Here's how:

  • Click the "Home" tab in Power BI and then click the "Edit Queries" button.
  • Then, under "Queries" on the left side of the screen, click on the name of the table you want to add the index to.

  • Then click on the "Add Column" tab and then click the "Index Column" button. (If you click the down arrow beside the Index Column button, you can decide what number to start the index with.)

    enter image description here

  • Then click "File" and "Close & Apply".