Forum Discussion
Helper IVResult Not as Expected - DAX Calculating Working Hours Between Dates
Community ChampionCMoppet I did this once: Net Work Duration (Working Hours) - Microsoft Fabric Community
Helper IVHello 🙂 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
Just tried it again....not sure what I'm missing...
- Greg_Deckler
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.
- CMoppet
Hello 🙂 Unfortunately not. I get the same result for every row of data. I presume I'm not adapting it properly for my data, but I can't see where the issue is. I marked it as 'Solved' as I am trying a different approach. I'd still be so grateful if you can see where I'm going wrong with your solution, as the alternative I've found runs really slowly...
- CMoppet
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