Forum Discussion
Date Difference by excluding weekends & holidays
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.
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://dropmefiles.com/x9SCB
5 Replies
- Ahmedx
Super User
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://dropmefiles.com/x9SCB - Ahmedx
If you need to pull a list of holidays from another table, then, of course, you can
https://dropmefiles.com/gsg8d - Ahmedx
let's say that the holidays are the following days (2023, 01, 19 - 2023, 01, 26 )
are you expecting this result?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
