Count how many dates are less than

[poweruser55]

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

[VahidDM · Accepted solution]

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/

[poweruser55]

Works perfect.. Could you also look at this one https://community.powerbi.com/t5/Desktop/AND-OR-Statements-in-DAX/m-p/2342831#M845048 it is much more complex and I am having issues @VahidDM