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
v-lionel-msft
Community Support
Community SupportHi 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 Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.