Forum Discussion

jbenson's avatar
jbenson
Helper III
4 years ago
Solved

Avg Wait Time

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 u...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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!