Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |