RANK date

[Anonymous]

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. 

[harshnathani]

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)

[amitchandak · Accepted solution]

@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]

Thank !