Forum Discussion
Working Hours between two datetimes M-F (Including Saturdays)
I'm trying to figure out to how to implement working hours from two different datetimes.
- M-F (8A-5P)
- SATURDAY (8A-4P)
Must disregard Holidays
I've tried using this method from Bill Szysz but I'm having a hard time incorporating the Saturday hours.
4 Replies
rogerthat Can you use a DAX solution? Net Work Duration (Working Hours) - Microsoft Power BI Community
Greg_Deckler Would the the solution also account for holidays? So if its a holiday, SLA hours should not be counted?
rogerthat You could have a holidy table and in the __NetWorkDays VAR formula you could do an EXCEPT around the CALENDAR statement to exclude the holidays. Also, in that same statement you would want <7 instead of <6 in order to include Saturdays.
