Calculate Business Hours using DAX (Working Hours in Power BI & Power Pivot - Excel)

Published: 29 July 2022
on channel: Power GI

15,823

190

Short and easy! You'll love this solution!
Link to file: https://powergi.net/resources/Calcula...

Workday = If(Weekday(Calendar_Table[Date]) = 7 || Weekday(Calendar_Table[Date]) = 1, 0,1)

Start =
var workDayStart = time(8,0,0)
var eachdate = DATEVALUE(Calendar_Table[Date])
return eachdate + workDayStart

End =
var workEndStart = time(17,0,0)
var eachdate = DATEVALUE(Calendar_Table[Date])
return eachdate + workEndStart

Resolution Time (Hrs) =
VAR _Start = 'Request Data'[Created At]
Var _End = 'Request Data'[Resolved At]
Return SUMX(
CALCULATETABLE(
Calendar_Table,
DATESBETWEEN(Calendar_Table[Date],_Start,_End),
Calendar_Table[Workday] = 1
),
MAX(MIN(Calendar_Table[End],_End) - MAX(Calendar_Table[Start],_Start),0) * 24
)

Watch video Calculate Business Hours using DAX (Working Hours in Power BI & Power Pivot - Excel) online without registration, duration hours minute second in high quality. This video was added by user Power GI 29 July 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 15,823 once and liked it 190 people.

876