Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Adding additional criteria to RANKX

I have a column which ranks by student code and date change using the following:   Rank = RANKX( FILTER( 'Table', [StudentID] = EARLIER( [StudentID] )), [ChangeDate] , , ASC, DENSE)   which give...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Hi Anonymous 

    Rank V2 =
RANKX (
    FILTER (
        Table1,
        Table1[StudentID] = EARLIER ( Table1[StudentID] )
            && Table1[AcademicYear] = EARLIER ( Table1[AcademicYear] )
    ),
    Table1[ChangeDate],
    ,
    ASC,
    DENSE
)

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

parry2k's avatar
parry2k
Super User
5 years ago

Anonymous try this

 

Rank  = RANKX( FILTER( 'Rank', 'Rank'[StudentID] = EARLIER( 'Rank'[StudentID] ) && 'Rank'[AcademicYear] = EARLIER('Rank'[AcademicYear])), 'Rank'[ChangeDate] , , ASC, DENSE)

 

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡