Short and easy! You'll love this solution!
Link to file: powergi.net/resources/Calculate_business_hrs_DAX.pbix
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
)
Негізгі бет Calculate Business Hours using DAX (Working Hours in Power BI & Power Pivot - Excel)
Пікірлер: 32