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

There is one slight error, that my session id's are in alpha numeric and so the format its format is text. And when I am using your suggested formula the following error is shown: 

 

DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.

 

I tried formatting it using format and value function but to no avail.  

 

 

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.