I am working with an issue where I need to calculate the difference between the 2 dates (datetime format) excluding weekends and non work hours. The work hours to be considered are between 9 am and 6pm , Mon - Fri .
The user wants to have a filter on the Start date.
I have tried a couple of solutions posted on the Power BI community , but they dont seem to be giving me the expected results.
For example in the dataset for Id = 17 , work hours should be close to 2 hours , considering the appliation was created on a Sunday.
Appreciate all the help.