Averages Times

[170323003]

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 😄

[harshnathani]

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 😄

[Anonymous]

// 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

[Anonymous]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[amitchandak]

@170323003 , you need to have a common row context for that. refer to my blog. Same is true for import mode

https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Differ...

[170323003]

Hi, ty for your response.

Although i didnt get 😞

Could you be more specific or explain me by an easier way?