Forum Discussion
datediff Hours
Thanks a lot Greg!
Your Quick measure was helpful to show my information in a nice format.
Use my Net Work Days quick measure to figure out the number of working days. Multiple by 24 and adjust depending on your start/end times. Sample data would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Net Work Days Quick Measure: https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/m-p/367362
Hi Greg,
Great solution with creating Network days function in power bi. Business days excluding holidays are accurate for my data output, but i am having trouble adjusting the code for business hours of 7:30am to 5pm. Where in the code do I adjust, and how do I adjust? Also, some date differences are under 1 hour, so would you able to code it for example '0 hours 13 minutes' as well?
Thanks,
Emma