Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

RANK date

Hello, From a date-time column, I would like to generate a "Rank" column indicating the order during the day. thanks in advance In the example below I have the left column and I would like to generate the right column in power bi. 

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try a new column

     

    rank(filter(Table, [date_debut].date = earlier([date_debut].date)),[date_debut],,asc,dense)

     

    Or create date column
    Date = [date_debut].date
    or
    Date = date(year([date_debut]),month([date_debut]),day([date_debut]))

     

    and then rank
    rank(filter(Table, [Date] = earlier([Date].date)),[date_debut],,asc,dense)

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Try a new column

     

    rank(filter(Table, [date_debut].date = earlier([date_debut].date)),[date_debut],,asc,dense)

     

    Or create date column
    Date = [date_debut].date
    or
    Date = date(year([date_debut]),month([date_debut]),day([date_debut]))

     

    and then rank
    rank(filter(Table, [Date] = earlier([Date].date)),[date_debut],,asc,dense)

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank !

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Create 2 Calculated Column

     

    Dates Only = DATE(YEAR(Table3[Date Time]),MONTH(Table3[Date Time]),Day(Table3[Date Time]))
    Ranking = RANKX(FILTER(Table3,Table3[Dates Only] = EARLIER(Table3[Dates Only])),Table3[Date Time])

     

     

    Regards,
    Harsh Nathani
    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)