Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello,
I have two columns in DD / MM / YYYY HH: MM: SS format for which I want to calculate the duration in hours worked.
The working day is between 8 a.m. and 6 p.m. It will therefore be necessary to exclude the period from 6 p.m. to 8 a.m.
Thank you
@RHB23 , There is blog on that, please check if that can help
https://exceleratorbi.com.au/calculating-business-hours-using-dax/
User | Count |
---|---|
98 | |
75 | |
74 | |
49 | |
26 |