Forum Discussion

villa1980's avatar
villa1980
Resolver II
1 year ago
Solved

Time Duration between rows

I am trying to look at the duration between the end date and next start date for each STARTDATE category. I am using the below DAX and is coming out with some weird results which I am struggling to ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    villa1980 

    since you have the index column , you can try this

     

    Measure =
    var _end=maxx(FILTER(all('Table'),'Table'[BAYDESC]=max('Table'[BAYDESC])&&'Table'[Index]=max('Table'[Index])-1),'Table'[ENDDATE])
    return DATEDIFF(_end,max('Table'[STARTDATE]),MINUTE)
     
villa1980's avatar
villa1980
Resolver II
1 year ago

Thank-you for the response, it is returning the below which is still not correct

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi villa1980 ， hello ryan_mayu and rajendraongole1, thank you for your prompt reply!

Per my test, I could use the following measure to calculate the differences between startdate as shown below:

NextTaskDuration = 
VAR _CurrentTaskStart = SELECTEDVALUE('Table'[STARTDATE])
VAR _NextTaskStart =
    CALCULATE(
        MIN('Table'[STARTDATE]),
        FILTER(
            ALL('Table'),
            'Table'[STARTDATE]> _CurrentTaskStart
        )
    )
VAR _TimeDifferenceInMinutes =
    IF(
        ISBLANK(_NextTaskStart),
        0,
        DATEDIFF(_CurrentTaskStart, _NextTaskStart, MINUTE)
    )
RETURN
    _TimeDifferenceInMinutes

Result:


You could also provide more details about your issue or upload a sample PBIX file for better troubleshooting.

 

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.