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,

 

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. 

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community 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
    Community 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
    Helper IV
    9 years ago

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

     

     

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

    Kumar11109,

     

    Please show us expected result based on your sample data.

  • Kumar11109's avatar
    Kumar11109
    Helper IV
    9 years ago

    v-chuncz-msft

     

    Some thing like this: 

     

     

     

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