Forum Discussion

Kumar11109's avatar
Kumar11109
Icon for Helper IV rankHelper 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
)
Kumar11109's avatar
Kumar11109
Icon for Helper IV rankHelper IV
9 years ago

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

Kumar11109's avatar
Kumar11109
Icon for Helper IV rankHelper 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
    Icon for Community Support rankCommunity 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
      Icon for Helper IV rankHelper 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. 

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

        Kumar11109,

         

        It works for your original sample data. You may need to check the actual data and change it accordingly. Better to learn more DAX basics before going ahead.