Forum Discussion
Create row id in a custom table
I have a custom table and custom column as below.
The following column is what im want the output to be
how do i use dax to do this?
Hi, profilewatercli
Thanks for PowerBigginer help. If you want to create a Index column by DAX, you can refer to following method.DAX:
Index = RANKX(ALL('Table'), 'Table'[Exam Session], , DESC, Dense)Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
3 Replies
Go to Power query (Right click on the table click Edit Option) then add Index column
For more Power BI tips and Tricks
https://powertipstricks.blogspot.com/ check out the blog
If this post helps Please Mark as a solutionIs there a way to do this using dax?
Hi, profilewatercli
Thanks for PowerBigginer help. If you want to create a Index column by DAX, you can refer to following method.DAX:
Index = RANKX(ALL('Table'), 'Table'[Exam Session], , DESC, Dense)Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
