Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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/
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
107 | |
99 | |
39 | |
30 |