Hi Team, 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…

Hi @Sim2312 The testdata file along with working pbix file is attached for your reference. Regards Kumail Raza Network_hours.pbix (48.4 KB) TestData.xlsx (26.3 KB)

Calculate the work hours between 2 dates( datetime) excluding weekends - 9 am - 6pm Mon-Fri

DAX DAX Calculations

hafizsultan March 17, 2020, 4:17am 2

Hi @Sim2312,

Please go through below solution. Hopefully, it will work in your case.