topic Re: Hours difference between two dates & exclude bank holidays and weekends in DAX Commands and Tips

Hours difference between two dates & exclude bank holidays and weekends

UjjawalTyagi518 — Tue, 12 Dec 2023 20:29:18 GMT

Hi there,

I am trying to find a simple way to calculate the hours difference between two dates. But I need to exclude bank holidays and weekends but also the calculation can only sum the hours in-between specified working hours(which is 9am to 6pm) . If something comes through outside of these working hours the sum would only start the next day at the working hour start time.

above are the refrence dates
Previous date is the start date of a task and Action date is the end date of the task.
I WANT TO DO THIS IN POWER QUERY ONLY

i will be very thankful, if u help me out with this logic
i need to do it on a urgent basics (ASAP)
link of the Pbix file is given below
https://1drv.ms/u/s!AsQOj7VQoTfbkUrTCIwpZCrE-968?e=aNZ97N

Re: Hours difference between two dates & exclude bank holidays and weekends

lbendlin — Sat, 16 Dec 2023 22:03:13 GMT

Re: Hours difference between two dates & exclude bank holidays and weekends

WBD_01 — Fri, 16 Aug 2024 11:17:47 GMT

Hello lbendlin ,

I have a very similar requirement, but with different working hours. Struggling to find where I make this adjustment, be very glad of your help on this.

Many thanks in advance.

Re: Hours difference between two dates & exclude bank holidays and weekends

lbendlin — Fri, 16 Aug 2024 11:35:11 GMT

WBD_01 Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.