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

Kumar11109's avatar
Kumar11109
Icon for Helper IV rankHelper IV
9 years ago

The formula didn't work on my sample data set also.   

 

 

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity 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
)
  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Kumar11109,

     

    Please show us expected result based on your sample data.

  • Kumar11109's avatar
    Kumar11109
    Icon for Helper IV rankHelper IV
    9 years ago

    v-chuncz-msft

     

    Some thing like this: 

     

     

     

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