Forum Discussion
Show Row dynamic number in a table
Hi all.
I have a doubt, I would like to show in a table a secuencial number like this:
In this case, it cannot be repeated, they always have to go up from 1 to X.
Any suggestion?
Anonymous , you might have to create rank and display
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measuresOr in your table, you can add an index column (This will be for the table)
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
3 Replies
- amitchandak
Super User
Anonymous , you might have to create rank and display
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measuresOr in your table, you can add an index column (This will be for the table)
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
Hi, thanks for your answer, finally I used this method that you indicated => https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
v-lionel-msftCommunity Support
Hi Anonymous ,
Step1, Add an index column in Power Query.
Step2, Create a measure.
Measure = RANKX( ALLSELECTED('Table'), CALCULATE( MAX([Index]) ), , ASC, Dense )Then you can get the dynamic number of the row.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.