Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
VK7
Frequent Visitor

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)

VK7_1-1675830717044.png


Thank you in advance.

 

1 ACCEPTED SOLUTION
Ahmedx
Super User
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
Screen Capture #274.png

View solution in original post

5 REPLIES 5
Ahmedx
Super User
Super User

If you need to pull a list of holidays from another table, then, of course, you can
https://dropmefiles.com/gsg8d
Screen Capture #279.pngScreen Capture #280.png

Ahmedx
Super User
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
Screen Capture #274.png

Ahmedx
Super User
Super User

let's say that the holidays are the following days (2023, 01, 19 - 2023, 01, 26 )
are you expecting this result?
Screen Capture #272.png

VK7
Frequent Visitor

Hi Ahmedx,

I've edited the initaly request more elaborately. 

VK7_0-1675830967104.png

 



@VK7 , refer if this can help

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

 

you have convert to days and hours post that

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.