Forum Discussion

bob57's avatar
bob57
Helper IV
3 years ago
Solved

Calculated column and RANKX

Hello,

I need to develop a calculated column to rank the Timestamp by EventId.

The desired result would look like this:

Thank you!

Bob

 

  • Timestamp Rank=RANKX(FILTER(Table,Table[EventId]=EARLIER(Table[EventId])),'Table'[Timestamp],,ASC)

2 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion

    Timestamp Rank=RANKX(FILTER(Table,Table[EventId]=EARLIER(Table[EventId])),'Table'[Timestamp],,ASC)

    • bob57's avatar
      bob57
      Helper IV

      Thank you so much! Now time for me to study and understand.

      Bob