Index without formula rankx

Question

Hello all,&nbsp;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?&nbsp;Thanks!

idrissshatila · Answer

Hello Anonymous ,&nbsp;You could add it in power query, refer to this article for instructions https://learn.microsoft.com/en-us/power-query/add-index-column&nbsp;If I answered your question, please mark my post as solution, Appreciate your Kudos 👍&nbsp;Follow me on Linkedin

anonymous · Answer

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.

Forum Discussion

Index without formula rankx

2 Replies

Related content

If formula

formula

DAX Formula Help

Multiple conditions Index

Index