Forum Discussion
170323003
Helper I
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 ...
170323003Helper I
Helper IOk, 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
)
)- 170323003
I got this error:
And i didnt get this part u send:
forgot to mention that Reservas[ResponseDate] it's a measure i created:
ResponseDate = ALL(Reservas[Date])although, if i use simply Reservas[Date] the error is the same