Forum Discussion

Aeolus's avatar
Aeolus
Frequent Visitor
6 years ago
Solved

Index Ranking user with time

Hi Community,   I hope you can help me with the following: I want to calculate the time duration of a specific process by a specific user (gebruiker) but have not got further than calculating the t...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Aeolus ,

     

    You could update your DAX :

    GR Index Total =
IF (
    Table[Process Description] = "Goods Receipt";
    RANKX (
        FILTER (
            Table;
            Table[Process Text] = "process_receipt"
                && 'Table'[gebruiker] = EARLIER ( 'Table'[gebruiker] )
        );
        Table[ID];
        Table[ID];
        ASC
    );
    0
)
    Start Time =
CALCULATE (
    FIRSTNONBLANK ( 'Table'[ret_dat]; 1 );
    FILTER (
        'Table';
        'Table'[GR Index Total]
            = EARLIER ( 'Table'[GR Index Total] ) - 1
            && 'Table'[gebruiker] = EARLIER ( 'Table'[gebruiker] )
    )
)

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Aeolus ,

 

You could update your DAX :

GR Index Total =
IF (
    Table[Process Description] = "Goods Receipt";
    RANKX (
        FILTER (
            Table;
            Table[Process Text] = "process_receipt"
                && 'Table'[gebruiker] = EARLIER ( 'Table'[gebruiker] )
        );
        Table[ID];
        Table[ID];
        ASC
    );
    0
)
Start Time =
CALCULATE (
    FIRSTNONBLANK ( 'Table'[ret_dat]; 1 );
    FILTER (
        'Table';
        'Table'[GR Index Total]
            = EARLIER ( 'Table'[GR Index Total] ) - 1
            && 'Table'[gebruiker] = EARLIER ( 'Table'[gebruiker] )
    )
)

 

Aeolus's avatar
Aeolus
Frequent Visitor
6 years ago

Hi V-eachen,

 

Works like a charm!!

 

Thank you,

Aeolus