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
Icon for Community Support rankCommunity Support
9 years ago

Kumar11109,

 

You may use the following DAX to add a calculated column.

Flag =
IF (
    MAXX (
        TOPN (
            1,
            FILTER ( Table1, Table1[Session ID] = EARLIER ( Table1[Session ID] ) ),
            Table1[Start Time], ASC
        ),
        Table1[Resource]
    )
        = 1,
    1,
    0
)
Kumar11109's avatar
Kumar11109
Icon for Helper IV rankHelper 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
    Icon for Community Support rankCommunity Support
    9 years ago

    Kumar11109,

     

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

    • 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.