Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

 

  • Hi Anonymous 

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

2 Replies

  • AlB's avatar
    AlB
    Community Champion

    Hi Anonymous 

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks, I figured it would be something easy