cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## 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.

1 ACCEPTED SOLUTION
Super User

@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 3
Community Champion

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)

Super User

@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
Not applicable

Thank !

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.