none
How to add a Serial Number or Row Number Column in Power BI? RRS feed

  • General discussion

  • You can edit the table by "Edit Query" Option. Find the Add Index Column in the "Add Column" Tab. You can see now the new column is added at the last. Customize the column to rename it as "SNO" or "ROW NUM" or anything preferred.

     

    Note:

    Observe that the first row contains zero. If you want to start the first number with 1 you can start "adding a new column" from Add Column tab. In the formula section you can write a formula as "[Index]+1". Here index is the column added earlier which starts with 0. Rename to the preferred column.

     

    You have a Row Number or Serial Number Column Ready.

    Tuesday, July 26, 2016 1:58 PM