Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be 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

Reply
Anonymous
Not applicable

Indexed numbered column

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

 

registration.png

1 ACCEPTED SOLUTION
AlB
Super User
Super User

Hi @Anonymous 

Try to add an index column in the query editor: Add Column -> Add Index column 

View solution in original post

2 REPLIES 2
AlB
Super User
Super User

Hi @Anonymous 

Try to add an index column in the query editor: Add Column -> Add Index column 

Anonymous
Not applicable

Thanks, I figured it would be something easy

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.