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.
I'm trying to rank some records by the date, but I'm getting rather unexpected results. Here's my column formula:
But here's the result I'm getting:
Solved! Go to Solution.
Hi @kman42 ,
When I use your expression to create a column, it returns "1" for each row. But, when use it to create a measure, it works well.
If you want to create a column, try this:
Date Rank Index 2 column = RANKX ( 'award', 'award'[award_begin_date],, DESC )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Write these 2 measures
Begin_Date = MIN(Award[award_begin_date])
Rank_Date = RANKX(ALLSELECTED(Award[award_begin_date]),[Begin_Date],,DESC)
Hope this helps.
Hello Ashish,
I was trying to implement your solution but I'm getting an error:
Hi,
Replace CALCULATE with RANKX
Oh how I didn't notice it! Thank you so much.
If you allow I have one more question, is there a way to reverse columns order with dates by having this measure created? Don't really know how to do this.
You are welcome. I do not understand your question.
So I would like to change the order of columns, the first column should be 4/1/2024 and the last should be 1/1/2024. I was thinking that creating this measure with rank could help me, but still no idea how to manage it. Hope it's more clear now.
Hi @kman42 ,
When I use your expression to create a column, it returns "1" for each row. But, when use it to create a measure, it works well.
If you want to create a column, try this:
Date Rank Index 2 column = RANKX ( 'award', 'award'[award_begin_date],, DESC )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |