Ignore certain time periods during duration calculations

[XeperRx]

Hello, 

I'm calculating total build time. Here is the DAX calculation that I'm using - 

Build Time = DATEDIFF('Job Management Historical'[Build Start], ('Job Management Historical'[Potting Staged]), MINUTE) + (DATEDIFF('Job Management Historical'[Build Resume Time], ('Job Management Historical'[Build Complete]), MINUTE))

I need to ignore certain time periods in this calculation - 

M-F : 12:00 PM - 12:30 PM 

M-Th :  4:30 PM - 8:00 AM

Weekends : F 4:00 PM - M 8:00 AM 

Thank you in advance for your help! 

[harshnathani · Accepted solution]

Hi @XeperRx ,

Please check if these help.

https://exceleratorbi.com.au/calculating-business-hours-using-dax/

https://exceleratorbi.com.au/calculating-elapses-business-hours-using-dax-part-2/

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

[XeperRx]

@harshnathani ,

Thank you!! This is exactly what I was looking for!