March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I do see similar posts to what I am looking for, but it seems like this would be simple DAX. I have a class registration system for internal training here in my organization and now I am creating a Power BI report to show those who are registered for a particular day and session. I would like the registrants to be numbered, in numeric order. (for those familiar, it would be a dim i as int; print i; i+=1). The underlying datatable does have an id column, but this would not work as it is just an identity spec.
I have found some examples of DAX that use RANKX, but maybe I am using it wrong. I just need this numbered column (1, 2, 3, etc) for a filtered Class session.
Thanks
Solved! Go to Solution.
Hi @Anonymous
Try to add an index column in the query editor: Add Column -> Add Index column
Hi @Anonymous
Try to add an index column in the query editor: Add Column -> Add Index column
Thanks, I figured it would be something easy
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
22 | |
19 | |
17 | |
9 | |
5 |
User | Count |
---|---|
37 | |
29 | |
16 | |
14 | |
12 |