Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I want to calculate the solution time between two log moments (date_time finished AND date_time required) based on working hours and business days. By this I mean that weekends, vacations, public holidays and leisure time are excluded from the formula. This will make my results more valid. It needs to be a Power Query formula.
It also needs to be possible to get negative results like this; in hours: -34:13:43 or in seconds: -14543.
An example:
Friday 25-2-2022 at 16:00 and Monday 28-2-2022 at 11:00. The answer needs to be 4 hours(I prefer the answer to be in seconds, so 14400). Because the workday ends at 17:00 on friday, so from 16 it is 1 hour. And starts again at Monday 8:00, till 11 it is 3 hours. So the result is 4 hours.
Who can help me?
Solved! Go to Solution.
@Anonymous See Working Hours. Net Work Duration (Working Hours) - Microsoft Power BI Community
@Anonymous See Working Hours. Net Work Duration (Working Hours) - Microsoft Power BI Community