How to create rank

TriveniN · ‎08-08-2023

Hi,

@mcaraballo Can you help me to create rank

Note: OccupiedRent and DateDiff are the measures

Below is the sample data

Expected Output:

mcaraballo · ‎08-08-2023

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 · ‎08-09-2023

Did it work? if so, please mark my post as a solution 😀

Ahmedx · ‎08-08-2023

pls try this

TriveniN · ‎08-08-2023

@Ahmedx : Thanks for quick response

getting an error when we create above column

Can you help me out to resolve issue

error details is circualr dependency was detected

Expected Output should be below

Helpful resources