"Variant of Events in Progress" any Idea on how to solve this..?

[krish003]

Hi All,

I have a scenario similar to "Events in Progress" but the data is at minute level.

Objective: Calculate total Hours worked by Employee

How can I build this in Dax??

My approach was to compare data in "row 1" with data in "row 2" and update the variables in iterator (sumx(tbl, var true_start_time=...,true_end_time=.. Return, ....some_complex_dax.....)

but even this approach fails for the case, where there is a gap in the overlapping time frames; just as in the case in the img.

Shoot your thoughts or point me to resources if there are any that solves this issue.

[v-piga-msft]

Hi @krish003,

Based on your information, I'm still a little confused about your logic. 

If it is convenient, could you share your data sample and your desired ouput in power bi.

I would appreciate it if you could describe your logic in more details.

Best Regards,

Cherry