topic Re: How to calculate the through put time of a process for partial workdays only in DAX Commands and Tips

How to calculate the through put time of a process for partial workdays only

MF_BSC — Tue, 11 Feb 2025 15:01:10 GMT

I am trying to create a through put time for a process. The output I am looking for is the hours in decimal format with one decimal place from the StartDate to FinishDate including partial days however excluding weekends. I have gotten the report to output DateDiff in hours including partial days in correct format however it includes weekends, I have gotten NetworkDays to work in hours however it rounds up to the complete day. I have gotten Datediff to list workdays only but not partial days in hours. Is there a why to get the output in hours for partial workdays only?

Lead time DateDIFF in DAX =

DATEDIFF(Query1[StartDate],Query1[FinishDate],HOUR)+

(DATEDIFF(Query1[StartDate],Query1[FinishDate],MINUTE)

-DATEDIFF(Query1[StartDate],Query1[FinishDate],Hour)*60)/60

Lead time DateDIFF in DAX =

DATEDIFF(Query1[StartDate],Query1[FinishDate],HOUR)+

(DATEDIFF(Query1[StartDate],Query1[FinishDate],MINUTE)

-DATEDIFF(Query1[StartDate],Query1[FinishDate],Hour)*60)/60

Lead time Datediff test =

VAR _Datediff=

CALCULATE(

SUM('Dates_2024'[Weekday]),

DATESBETWEEN('Dates_2024'[Date],'Query1'[StartDate],'Query1'[FinishDate])

)-1

RETURN

IF(_Datediff<0,0,_Datediff)

Re: How to calculate the through put time of a process for partial workdays only

johnt75 — Tue, 11 Feb 2025 15:18:52 GMT

You could combine the approaches you have tried. First work out the total difference including non-working days, then count the number of working days, multiply that by 24 and take it off the total difference.

Re: How to calculate the through put time of a process for partial workdays only

DataNinja777 — Tue, 11 Feb 2025 15:20:58 GMT

Hi MF_BSC ,

Since you have start dates and end dates, the best approach to address your requirement is to use a disconnected calendar table to calculate the duration flexibly. With the disconnected table, you will be able to address the weekend etc., and time intelligence function in the calendar table.

Best regards,

Re: How to calculate the through put time of a process for partial workdays only

MF_BSC — Tue, 11 Feb 2025 18:31:01 GMT

I found an you tube video that does just as you described.

Calculated Busines Hours using DAX (Working Hours in Power BI & Power Pivot-Excel) by Power GI