DAX formula to create a time measure between start and end of activities

[OHM]

I monitor apr. 200 processes. Each process typicaly contains 5 activities. Today I monitor start and end of each process, but I need a solution to measure the time from start act. 2 to end act. 4 in each prosess.

Any suggestions?

[v-caliao-msft]

@OHM,

Please share us some sample data. Generally, we can use the DAX to get the difference between two datetime field.

Measure = DATEDIFF(MAX(Table2[Start]),MAX(Table2[End]),SECOND)

Regards,

Charlie Liao