Forum Discussion

poweruser55's avatar
poweruser55
Icon for Helper IV rankHelper IV
4 years ago
Solved

Count how many dates are less than

I am getting a syntax error I want it to count how many times when the expected installation date is less than the OLI close date

Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi poweruser55 

     

    Try this:

     

    Var _A =
CALCULATE (
    COUNTROWS ( '999 Funnel' ),
    FILTER (
        '999 Funnel',
        '999 Funnel'[Expected Installation Date] < '999 Funnel'[Oli.Close Date]
    )
)

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

2 Replies