Forum Discussion
Anonymous
4 years agoNot applicable
Ranking Dates
Hi All,
I think this is a simple question though I havent been able to figure out. What is the best way to assign a rank or index based on one Date column that assigns a number based on distinct Dates?
For example, if you only had the first "Date" Column below, how would you create the "Rank" column shown below in PowerBI to assign a rank based on distinct dates from most recent to oldest?
Best,
JJ
Hi,
Create a below Column in a particular table :
_RankColumn = RANKX( Sheet141, Sheet141[Date], , ,Dense)Appreciate your Kudos
2 Replies
- MahyarTF
Memorable Member
Hi,
Create a below Column in a particular table :
_RankColumn = RANKX( Sheet141, Sheet141[Date], , ,Dense)Appreciate your Kudos - AnonymousNot applicable
Thanks!