Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |