Calculate Average Time To between to columns that ...

SWI-Inc · ‎10-18-2021

Hello

i have two colums that contain a date and time. I added a calculated column to show the difference in days hours, minutes, and seconds. My issues are (1) i need to exlude any weekend or holiday hours, (2) i need to be able to summerize the colmun as i am attepmting to find the average time it takes for an order to pick and ship. This is a link below to my file

https://drive.google.com/drive/folders/1P0_5c8OZQAp3dpwPDTgVF9NWNvl4k_iQ?usp=sharing

amitchandak · ‎10-18-2021

@SWI-Inc , if you are looking for business hours, check if this blog can help

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

SWI-Inc · ‎10-21-2021

This hasnt worked for me. i used the final formula matt posted. Here is my file. i need the time between the pick date and ship date expressed in hours

https://drive.google.com/drive/folders/1P0_5c8OZQAp3dpwPDTgVF9NWNvl4k_iQ?usp=sharing

Calculate Average Time To between to columns that contain Time and Date, excluding weekends

Helpful resources

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - January 2025

A Year in Review - December 2024

New Offer! Become a Certified Fabric Data Engineer

Calculate Average Time To between to columns that contain Time and Date, excluding weekends

Helpful resources

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - January 2025

A Year in Review - December 2024