how to calculate total hours from two dates skipping working hours and weekends

[omarevp]

Hello guys.

I´m trying to calculate working hours from two dates: Order_date (first date) and Created_date (Second date), considering that sometimes the first date might be an empty row.

The thing is that I want to exclude non-working hours, weekends and holidays.

Would you please help me? thanks in advance.

[v-juanli-msft · Accepted solution]

Hi omarevp

I found similar issue solved , see this link.

to exclude holidays ,you need to create a table contains holidays date, then relate this table to the calendar table(which is created in the DAX)

If you have any question, please feel free to ask me.

Best regards

Maggie