Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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!
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
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!