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 c...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI Boja

     

    Try this calculated column

     

    RANK_ =
RANKX (
    FILTER ( Table1, Table1[Platform] = EARLIER ( Table1[Platform] ) ),
    Table1[Version],
    ,
    DESC,
    DENSE
)
Boja's avatar
Boja
Icon for Advocate II rankAdvocate II
8 years ago

It works perfectly. Thanks Zubair!