Creating an index column for Power Bi

Question

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

Answer 1

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.)

  

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