Date Difference by excluding weekends & holidays

[VK7]

Hello,
I'm having two date columns as shown below, I need to bring the output as the difference between start & end date.
1) While achieving this I should Ingore the Weekends. (eg. Sat & Sun)
2) I'm having local holidays list, need to ignore that as well while taking differences.
OUTPUT format should be in hours. (eg. 26.01.2023 as hoilday)

Thank you in advance.

[Ahmedx]

If you need to pull a list of holidays from another table, then, of course, you can
https://dropmefiles.com/gsg8d

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://dropmefiles.com/x9SCB

[Ahmedx]

let's say that the holidays are the following days (2023, 01, 19 - 2023, 01, 26 )
are you expecting this result?

[VK7]

Hi Ahmedx,

I've edited the initaly request more elaborately. 

[amitchandak]

@VK7 , refer if this can help

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

you have convert to days and hours post that