Forum Discussion

170323003's avatar
170323003
Icon for Helper I rankHelper I
6 years ago

Averages 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 ...
average
Date
DAX
Help me please
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    170323003
    Icon for Helper I rankHelper I
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago
      // 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's avatar
        170323003
        Icon for Helper I rankHelper I
        6 years ago

        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