Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello,
I need to develop a calculated column to rank the Timestamp by EventId.
The desired result would look like this:
Thank you!
Bob
Solved! Go to Solution.
Timestamp Rank=RANKX(FILTER(Table,Table[EventId]=EARLIER(Table[EventId])),'Table'[Timestamp],,ASC)
Timestamp Rank=RANKX(FILTER(Table,Table[EventId]=EARLIER(Table[EventId])),'Table'[Timestamp],,ASC)
Thank you so much! Now time for me to study and understand.
Bob
User | Count |
---|---|
16 | |
13 | |
12 | |
11 | |
11 |
User | Count |
---|---|
19 | |
14 | |
14 | |
11 | |
9 |