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,

 

Simply change it to VALUE ( Table1[Resource] ) or = "1".

Kumar11109's avatar
Kumar11109
Helper IV
9 years ago

Sorry, but I did not understand. Could you explain it again. 

  • Kumar11109's avatar
    Kumar11109
    Helper IV
    9 years ago

    And my session id's are in the alpha numeric format, not my resources ids. 

  • Kumar11109's avatar
    Kumar11109
    Helper IV
    9 years ago

    And my session id's are in the alpha numeric format, not my resources ids. 

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

      Kumar11109,

       

      The data type of session id doesn't matter in formula above. Share the .pbix file if convenient.

      • Kumar11109's avatar
        Kumar11109
        Helper IV
        9 years ago

        Can you rewrite the formula, because did run successfully but it's resulting in only 0? I am attaching an image.