Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculated column for rank within group

Hi, I have data including a unique session id, a timestamp for the different events within that session and their names. I would like to create a column that shows the rank of each event within the ...
Need Help
  • NaveenGandhi's avatar
    NaveenGandhi
    3 years ago

    Hello Anonymous 

     

    Use the below Measure to populate the required result.

     

    Rank Column =
    RANKX(
        FILTER(
            rankkx,
            rankkx[Session_ID] = EARLIER(rankkx[Session_ID]) &&
            (rankkx[Timestamp] < EARLIER(rankkx[Timestamp]) ||
            rankkx[Name] < EARLIER(rankkx[Name]))
        ),
        rankkx[Timestamp],
        ,
        ASC,
        Dense
    )

     

    let me know if this helps.
     
    If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
NaveenGandhi's avatar
NaveenGandhi
Icon for Memorable Member rankMemorable Member
3 years ago

Hello Anonymous 

 

Use the below Measure to populate the required result.

 

Rank Column =
RANKX(
    FILTER(
        rankkx,
        rankkx[Session_ID] = EARLIER(rankkx[Session_ID]) &&
        (rankkx[Timestamp] < EARLIER(rankkx[Timestamp]) ||
        rankkx[Name] < EARLIER(rankkx[Name]))
    ),
    rankkx[Timestamp],
    ,
    ASC,
    Dense
)

 

let me know if this helps.
 
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.