Date Difference

Hi Taro_Gulat 

Thank you very much ryan_mayu for your prompt reply.

For your question, here is the method I provided:

Here's some dummy data

"Table"

Create a measure.

Date Difference = 
VAR MinStartDateA = 
CALCULATE(
    MIN('Table'[Start Date]),
    FILTER(ALL('Table'), 'Table'[Type] = MAX('Table'[Type]) && 'Table'[Step] = "A")
)
VAR MinEndDateB = 
CALCULATE(
    MIN('Table'[End Date]),
    FILTER(ALL('Table'), 'Table'[Type] = MAX('Table'[Type]) && 'Table'[Step] = "B")
)
VAR TimeDifference = DATEDIFF(MinStartDateA, MinEndDateB, SECOND)
RETURN
IF(
    SELECTEDVALUE('Table'[End Date]) = MinEndDateB,
    FORMAT(INT(TimeDifference / 3600), "00") 
    & ":" & 
    FORMAT(INT(MOD(TimeDifference, 3600) / 60), "00") 
    & ":" & 
    FORMAT(MOD(TimeDifference, 60), "00"),
    BLANK()
)

Here is the result.

Regards,

Nono Chen

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