Forum Discussion
CMoppet
Helper IV
2 years agoResult Not as Expected - DAX Calculating Working Hours Between Dates
Hello I am using DAX I found on a forum to help me calculate Response Time between two dates, only within working hours and on working days. Below, you can see the DAX and some results: I...
- 2 years ago
CMoppet I did this once: Net Work Duration (Working Hours) - Microsoft Fabric Community
CMoppet
Helper IV
2 years agoHello 🙂 I've already tried your method today! It didn't like me! All my results were 510...for every row. I couldn't figure out why! Anything obvious wrong with the different approach I used above?
CMoppet
Helper IV
2 years agoHello again! Just one more thing....I really want to make your method work, and add in something that recognises if a date is in my Holidays list, as we shouldn't count internal response time on those dates. Is this possible, please? Thank you