Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 | |
ATL00089 - Marion Houston - LE1 | 2050 | |
ATL00089 - Marion Houston - LE1 | 2250 | 0 |
ATL00096 - Nicholas M. Guerra - LE1 | 1900 | |
ATL00096 - Nicholas M. Guerra - LE1 | 2100 | 0 |
Expected Output:
NAME | OccupiedRent | DateDiff | Rank |
ATL00001 - Davina Roberts - LE2 | 2550 | 1 | |
ATL00089 - Marion Houston - LE1 | 2250 | 0 | 1 |
ATL00089 - Marion Houston - LE1 | 2050 | 2 | |
ATL00096 - Nicholas M. Guerra - LE1 | 2100 | 0 | 1 |
ATL00096 - Nicholas M. Guerra - LE1 | 1900 | 2 |
Hi @TriveniN , hope you are doing well.
I created a table with the sample data and then I created this column:
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!
pls try this
@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
NAME | OccupiedRent | DateDiff | Rank |
ATL00001 - Davina Roberts - LE2 | 2550 | 1 | |
ATL00089 - Marion Houston - LE1 | 2250 | 0 | 1 |
ATL00089 - Marion Houston - LE1 | 2050 | 2 | |
ATL00096 - Nicholas M. Guerra - LE1 | 2100 | 0 | 1 |
ATL00096 - Nicholas M. Guerra - LE1 | 1900 | 2 |
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |