October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
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 !
User | Count |
---|---|
103 | |
97 | |
96 | |
85 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |