Calculate consecutive working days and working hours

[Sashwato]

Hello all,

I am in need of help to work this solution out. We are having a dataset that we pull in currently with the information about Employees. The table contains the following details:

1. Name of the employee

2. Date

3. Start Time

4. End Time

5. Number of hours worked (if any)

The questions is: How do you calculate how many times a person worked 5 days in a row and overall over 40 hours in those 5 days?

Let me know if anyone has any idea. Will be highly appreciated!

Regards!

[v-henryk-mstf]

Hi @Sashwato ,

Workaround:

According to your needs, it can be reproduced in powerbi desktop. First, you can filter out the working days in the date, and then use dax to create a measure to obtain the cumulative value of "end time-start time" in the working day.

If there is still a problem, can you provide a test data model and a screenshot of the expected result, so that I can do further testing and solve your problem as soon as possible.

Looking forward to your reply.

Best Regards,
Henry

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

[amitchandak]

@Sashwato , refer if my blog on the topic can help

https://community.powerbi.com/t5/Quick-Measures-Gallery/Power-BI-Continuous-Streak-One-Day-Differenc...

or this

https://stackoverflow.com/questions/57603253/counting-consecutive-fails-in-test-results-in-power-bi

[Sashwato]

Hi Amit,

I looked through your links. Any idea how I can map the same keeping in mind Employees names. In your tutorial link, I am unable to get an idea on New Start Date, New End Date and Continuous Date Calculated columns created.

Regards!