Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Index without formula rankx

Hello all,


I would like to add a ranking to a table. It should start from one and calculate +1 until the end of the table. Sorting does not matter. It should always be counted from 1 to the end. If I do this with Rankx(), the creation of the table is extremely slow.
Is there another way to add the index?



Frequent Visitor


No sorry.

I would like to have an extra column in my Visual table, as indicated by the red box. This should count down the rows in the current display, how is this possible. It should start with 1 and then +1 each time.

Community Champion
Community Champion

Hello @JustDub ,


You could add it in power query, refer to this article for instructions


If I answered your question, please mark my post as solution, Appreciate your Kudos 👍


Follow me on Linkedin

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors