Forum Discussion
RANKX by date
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:
Hi Anonymous ,
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,
IceyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Icey
Community Support
Community SupportHi Anonymous ,
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.