Forum Discussion

Kumar11109's avatar
Kumar11109
Helper IV
9 years ago
Solved

Tagging Videos For each session

I have a data set in which I need to tag resources used in a session, starting from 1. I am attaching an image for a sample of my data set. Please help me...     
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    Kumar11109,

     

    Check if RANKX Function works.

    Rank =
RANKX (
    FILTER ( Table1, Table1[Session ID] = EARLIER ( Table1[Session ID] ) ),
    Table1[Start Time],
    ,
    ASC,
    SKIP
)
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
9 years ago

Kumar11109,

 

Please show us expected result based on your sample data.

Kumar11109's avatar
Kumar11109
Helper IV
9 years ago

v-chuncz-msft

 

Some thing like this: 

 

 

 

Aren't there any commands like "Tag" found in stata for power bi. 

 

 

 

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    9 years ago

    Kumar11109,

     

    Check if RANKX Function works.

    Rank =
RANKX (
    FILTER ( Table1, Table1[Session ID] = EARLIER ( Table1[Session ID] ) ),
    Table1[Start Time],
    ,
    ASC,
    SKIP
)