Forum Discussion

Boja's avatar
Boja
Icon for Advocate II rankAdvocate II
8 years ago
Solved

Distinct Rank for each criteria

Hello,

 

Could you please help me make a rank col for the following dataset? Namely, the rank 1 should be assigned to the newest app version on each platform no matter the problem field. The rank column should be updated with every new release, so the newest version is always ranked first. Do you have any idea?

 

thanks

 

PlatformVersionProblemRank
Android8.18Message1
Android8.18Call1
Android8.18Network1
Android8.18Video1
Android8.16Call2
Android8.16Network2
Android8.16Video2
Android8.15Message3
Android8.15Call3
Android8.15Network3
Android8.14Call4
iOS8.1Video1
iOS8.1Call1
iOS8.1Network1
iOS8.09Network2
iOS8.08Call3
iOS8.08Video3
iOS8.08Video3
iOS8.07Call4
Win12Network1
Win12Call1
Win11Network2
Win11Video2
Win11Message2
Win10Call3
Win9Video4
Need Help

3 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago

    HI Boja

     

    Try this calculated column

     

    RANK_ =
RANKX (
    FILTER ( Table1, Table1[Platform] = EARLIER ( Table1[Platform] ) ),
    Table1[Version],
    ,
    DESC,
    DENSE
)