Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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)
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)
@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)
Thank !
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |