Forum Discussion

GunnerJ's avatar
GunnerJ
Icon for Post Patron rankPost Patron
7 years ago
Solved

Task Times. Finding Time between events after sorts

I need to find the time between two tasks to determine how long each individual task takes. To be successful my code needs to only compare rows of the same Service order number, then be sorted by EVE...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, GunnerJ 

    If so, try this formula

    Task Time = 
VAR temp =
    TOPN (
        1,
        FILTER (
            Workflow,
            Workflow[BI_SO_NBR] = EARLIER ( Workflow[BI_SO_NBR] )
                && Workflow[BI_WRKFLW_TASK_SEQ_NBR] < EARLIER ( Workflow[BI_WRKFLW_TASK_SEQ_NBR] )
              
        ),
        Workflow[BI_SO_NBR], DESC,
        Workflow[BI_EVENT_DT_TM], DESC,
        Workflow[BI_WRKFLW_TASK_SEQ_NBR], DESC
    )
RETURN
    IF (
        ISEMPTY ( temp ),
        0,
        DATEDIFF (
            Workflow[BI_EVENT_DT_TM],
            MINX ( temp, Workflow[BI_EVENT_DT_TM] ),
            SECOND
        )
    ) * -1

    Result:

     

    Best Regards,

    Lin

GunnerJ's avatar
GunnerJ
Icon for Post Patron rankPost Patron
7 years ago