Date1 greater than Date 2 formula

[rachaelwalker]

I am looking for help with my DAX formula to show if Install Date > Ship Date then flag it as a 1 otherwise 0. Currently, I am using the formula below but I don't want it to calculate for products with no ship dates. 

Past Due Flag = IF('IV_Product'[Install Date] > 'IV_Product'[Ship Date], 1, 0)

[edhans · Accepted solution]

Try this @rachaelwalker 

Past Due Flag =
IF(
    ISBLANK( 'IV_Product'[Ship Date] ),
    BLANK,
    IF(
        'IV_Product'[Install Date] > 'IV_Product'[Ship Date],
        1,
        0
    )
)

If ShipDate is blank, it returns blank, otherwise it does your normal  1/0 result.

[edhans · Accepted solution]

Try this @rachaelwalker 

Past Due Flag =
IF(
    ISBLANK( 'IV_Product'[Ship Date] ),
    BLANK,
    IF(
        'IV_Product'[Install Date] > 'IV_Product'[Ship Date],
        1,
        0
    )
)

If ShipDate is blank, it returns blank, otherwise it does your normal  1/0 result.

[Anonymous · Accepted solution]

Just a small thing you missed is that you didn't add parenthesis after BLANK. It Should be BLANK().

Everything else is correct.

[rachaelwalker]

@Anonymous @edhans  Thank you both!