Forum Discussion
Result Not as Expected - DAX Calculating Working Hours Between Dates
- 2 years ago
CMoppet I did this once: Net Work Duration (Working Hours) - Microsoft Fabric Community
CMoppet I did this once: Net Work Duration (Working Hours) - Microsoft Fabric Community
- CMoppet2 years ago
Helper IV
Hello 🙂 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?
- CMoppet2 years ago
Helper IV
Just tried it again....not sure what I'm missing...
- Greg_Deckler2 years ago
Community Champion
CMoppet So, did you get it to work? It's marked as solved so I just wanted to follow up and see if you were able to get it to work.
- CMoppet2 years ago
Helper IV
Hello 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
- CMoppet2 years ago
Helper IV
As an add on, when I did it, I got errors because some of my rows have no start date or time. And it didn;t seem to like that. For the rows without any dates, I just want blank results....