Forum Discussion

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    SillySuzy , try like

     

    Within90DaysPurchases =
    var _max = calculate(Min(Sales[OrderDate]), filter(ALLSELECTED ( Sales ), Sales[CustomerKey] = MAX ( Sales[CustomerKey] ) ))
    return
    CALCULATE (
    COUNTROWS ( Sales ),
    filter( ALLSELECTED ( Sales ),
    Sales[CustomerKey] = MAX ( Sales[CustomerKey] ) &&
    Sales[OrderDate] > _max &&
    Sales[OrderDate] < _max + 90
    ) )

    • SillySuzy's avatar
      SillySuzy
      Regular Visitor
      2 years ago

      I appreciate your help, but I cant use Filter(), sadly.