Forum Discussion

TriveniN's avatar
TriveniN
Helper II
3 years ago

How to create rank

Hi, mcaraballo Can you help me to create rank   Note: OccupiedRent and DateDiff are the measures Below is the sample data NAME OccupiedRent DateDiff ATL00001 - Davina Roberts - LE2 2550...
Need Help
mcaraballo's avatar
mcaraballo
Advocate III
3 years ago

Hi TriveniN , hope you are doing well.

 

I created a table with the sample data and then I created this column:

Columna = RANKX(filter(tabla, Tabla[NAME] = EARLIER(Tabla[NAME]) ), Tabla[OccupiedRent], , DESC,Dense)
 

Please try this.

Regards,
Mariano.
Please, visit this idea and vote it if you like it ! Ability to show/hide any object based on a conditi... - Microsoft Fabric Community

 

DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO!

  • mcaraballo's avatar
    mcaraballo
    Advocate III
    3 years ago

    Hi TriveniN, 

    Did it work? if so, please mark my post as a solution ğŸ˜€