Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 😄
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
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)
// 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
)
)
I got this error:
And i didnt get this part u send:
forgot to mention that Reservas[ResponseDate] it's a measure i created:
@170323003 , you need to have a common row context for that. refer to my blog. Same is true for import mode
Hi, ty for your response.
Although i didnt get 😞
Could you be more specific or explain me by an easier way?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
19 | |
19 | |
15 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |