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 ...
// 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
)
)
170323003Helper I
Helper II 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