Forum Discussion
Helper IAverages Times
GM!
So, I need to get the average response time of bookings by warehouse and by equipment.
.......
The dates are from different tables.
How can i do this? I know i'll need some formulas, but i cant reach them atm.
If you need more info tell me!
TY everyone 😄
7 Replies
- amitchandak
Super User
170323003 , you need to have a common row context for that. refer to my blog. Same is true for import mode
170323003Hi, ty for your response.
Although i didnt get 😞
Could you be more specific or explain me by an easier way?
Hi 170323003 ,
You need to share more information.
Sharing 2 columns with Date and Time will not help.
Try using DATEDIFF and then Average.
Regards,
Harsh Nathani
- 170323003
Ok, lets go:
I want to know, in average, how many time do bookings take to be allocated.
The relations are
Bookings ---> Equipment ---> Reserve
I've tried something that is wrong i guess, because there's no direct relation between bookings and reserves:
(measure)
AvgResponseTime = AVERAGEX(Bookings, DATEDIFF(Bookings[Date], Reservas[ResponseDate],HOUR))I'm hardstuck at this one, so if anyone can help me, i would appreciate 😄// For this to work, you have to have: // Bookings * -> 1 Equipment on [EquipmentID] // Bookings * -> Reservas on [ReserveID] AvgResponseTime = AVERAGEX( // This is the table you show // in the picture, I assume. Bookings, DATEDIFF( Bookings[Booking Date], RELATED( Reservas[ResponseDate] ), HOUR ) )
