topic Re: Averages Times in DAX Commands and Tips

Averages Times

170323003 — Thu, 13 Aug 2020 08:22:12 GMT

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 😄

Re: Averages Times

amitchandak — Wed, 05 Aug 2020 08:28:01 GMT

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-Difference-Across/ba-p/934397#M451

Re: Averages Times

170323003 — Wed, 05 Aug 2020 09:05:41 GMT

Hi, ty for your response.

Although i didnt get 😞

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

Re: Averages Times

Anonymous — Wed, 05 Aug 2020 16:54:18 GMT

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

Re: Averages Times

Anonymous — Wed, 05 Aug 2020 19:54:21 GMT

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

Re: Averages Times

170323003 — Thu, 13 Aug 2020 08:22:44 GMT

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 😄

Re: Averages Times

Anonymous — Thu, 06 Aug 2020 14:50:23 GMT

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

Re: Averages Times

170323003 — Thu, 06 Aug 2020 16:10:29 GMT

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