Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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

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.emp_hrs.JPG

Resident Rockstar
Resident Rockstar

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,


Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors