Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi
I have two date fields with times. I want to calculate the response time of mins between Start and Finish excluding lunch breaks, weekends, and holidays.
I found the formula to exclude weekends, and holidays but how to exclude lunch also
Lunch Hour 13:00 to 14:00
25-10-22 10:02 | 31-10-22 16:58 |
31-10-22 14:40 | 31-10-22 16:48 |
31-10-22 12:17 | 31-10-22 16:50 |
31-10-22 15:03 | 31-10-22 17:00 |
31-10-22 15:45 | 31-10-22 16:44 |
31-10-22 14:19 | 31-10-22 16:44 |
@Dun713 , refer if this can help
https://exceleratorbi.com.au/calculating-business-hours-using-dax/
User | Count |
---|---|
80 | |
77 | |
64 | |
48 | |
45 |
User | Count |
---|---|
102 | |
44 | |
39 | |
39 | |
36 |