Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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's avatar
    MahyarTF
    Icon for Memorable Member rankMemorable Member

    Hi,

    Create a below Column in a particular table :

    _RankColumn = RANKX( Sheet141, Sheet141[Date], , ,Dense)
    Appreciate your Kudos
  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks!