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/

     

     

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
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/