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

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.

  • 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
)
  • 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,

     

    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.