Tagging Videos For each session

[Kumar11109]

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

[v-chuncz-msft · Accepted solution]

@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]

@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]

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]

@Kumar11109,

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

[Kumar11109]

Sorry, but I did not understand. Could you explain it again. 

[Kumar11109]

And my session id's are in the alpha numeric format, not my resources ids. 

[v-chuncz-msft]

@Kumar11109,

The data type of session id doesn't matter in formula above. Share the .pbix file if convenient.

[Kumar11109]

Can you rewrite the formula, because did run successfully but it's resulting in only 0? I am attaching an image. 

[v-chuncz-msft]

@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]

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

[v-chuncz-msft]

@Kumar11109,

Please show us expected result based on your sample data.

[Kumar11109]

@v-chuncz-msft

Some thing like this: 

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

[v-chuncz-msft · Accepted solution]

@Kumar11109,

Check if RANKX Function works.

Rank =
RANKX (
    FILTER ( Table1, Table1[Session ID] = EARLIER ( Table1[Session ID] ) ),
    Table1[Start Time],
    ,
    ASC,
    SKIP
)

[Kumar11109 · Accepted solution]

@v-chuncz-msft

RANKX worked, thanks. 

[Kumar11109]

And my session id's are in the alpha numeric format, not my resources ids.