Hello DNA Team,
After doing everything to no avail have decided to seek out help. You assistance will be highly appreciated.
Here it is. It is actually a commonly asked question as Brian mentioned in one of the videos that it has been asked for like 24 times in different scenarios and have gone through almost all of them to no avail.
I’m tasked with doing the dreaded calculation excluding weekdays and Holidays. While many examples count the no of days takenWDM_Test_Data.pbix (157.6 KB) , the business wants to see the results in Days, Hours, Minutes, and Seconds working hours being 24hrs.
@ Merrissa, have gone through your recommendation to Saiyz and Swim someone forgive my spelling, and tried to follow through Bill sysz formula but couldn’t make it work.
The tricky part is that I have to calculate everything from ‘TO CREATION DATE’ to the next step . Everything stems from TO Creation Date as I’m tracing time taken in a production process and then compare the time taken between each stage with weekends and Holidays included and not included.
Have calculated the duration with weekends and holidays included using the DateDiff function and then showed the result in Days, Hours, Mins and secs as required but have tried to make the same formula work without weekends and holidays to no success.
Attached is the pbix file. please let me know if you need more info on this. A timely response on this will be highly appreciated. Thank you so much!