Solved: Avg Wait Time

jbenson · ‎02-08-2022

I am looking for a measure that will tell me the avg wait time of truck waitng to be loaded. i have the initial start time of each ticket and the final time when the truck leaves. what formula do i use to find the average time

Anonymous · ‎02-10-2022

Hi @jbenson ，

I created a sample table.

Then create a measure.

Avg Wait Time = 
VAR _days = SUMX('Table',DATEDIFF('Table'[StartTime],'Table'[EndTime],SECOND))/86400/COUNTROWS('Table') 
VAR _times = FORMAT(_days+TIME(0,0,0),"h\hm\ms\s")
VAR _day = INT(_days)
RETURN
IF(_day<>0,_day&"\d"&_times,_times)

The result should be like this.

Attach the pbix file for reference.

Best Regards,

Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

View solution in original post

Anonymous · ‎02-21-2022

Hi，

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.😊

Best Regards,

Community Support Team_Gao

Anonymous · ‎02-10-2022

Hi @jbenson ，

I created a sample table.

Then create a measure.

Avg Wait Time = 
VAR _days = SUMX('Table',DATEDIFF('Table'[StartTime],'Table'[EndTime],SECOND))/86400/COUNTROWS('Table') 
VAR _times = FORMAT(_days+TIME(0,0,0),"h\hm\ms\s")
VAR _day = INT(_days)
RETURN
IF(_day<>0,_day&"\d"&_times,_times)

The result should be like this.

Attach the pbix file for reference.

Best Regards,

Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!