DATEDIFF Returns a Blank()

Hi Anonymous ,

Generally, DATEDIFF function can automatically return 0.

You say you want to "Count Number of records where the ExpiryDate is more than 6 months old", so do you have another formula of count?

In my sample, I also create a count measure.

measure =
CALCULATE (
    COUNT ( location[expiry_date] ),
    FILTER ( 'location', DATEDIFF ( 'location'[expiry_date], TODAY (), MONTH ) > 1 )
)

Get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.