Forum Discussion

Samhunt's avatar
Samhunt
Icon for Helper II rankHelper II
2 years ago
Solved

Help with formula

Hi guys,    I used the following formula,   Average lead Time = CALCULATE(     AVERAGE(Bookings[Booking Lead Time]),     Bookings[Status] = "Paid" || Bookings[Status] = "Confirmed" )   So ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Samhunt ,

     

    Please try code as below to create a measure.

    Average lead Time =
VAR _STATUSLIST =
    CALCULATETABLE (
        VALUES ( Bookings[Status] ),
        ALLEXCEPT ( Bookings, Bookings[ID] )
    )
RETURN
    CALCULATE (
        AVERAGE ( Bookings[Booking Lead Time] ),
        FILTER ( Bookings, "Paid" IN _STATUSLIST && "Confirmed" IN _STATUSLIST )
    )


    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Samhunt ,

 

Please try code as below to create a measure.

Average lead Time =
VAR _STATUSLIST =
    CALCULATETABLE (
        VALUES ( Bookings[Status] ),
        ALLEXCEPT ( Bookings, Bookings[ID] )
    )
RETURN
    CALCULATE (
        AVERAGE ( Bookings[Booking Lead Time] ),
        FILTER ( Bookings, "Paid" IN _STATUSLIST && "Confirmed" IN _STATUSLIST )
    )


Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.