Date Within next 3 Months Dax

[LYeo87]

What do I need to do to correct this expression? 

Insurance Expiring Next 3 Months? = IF([Insurance Expiry Date]<(DATEADD(TODAY,+3,MONTH),"Yes","No"))

Insurance Expiry Date is a column of simple dates. I'm just looking to return Yes/No if they fall within the next 3 Months. 

[MFelix · Accepted solution]

Hi @LYeo87 .

Date add only accepts a column has initial syntax so you cannot use today has a first argument.

I would suggest you would use:

Insurance Expiring Next 3 Months? = IF([Insurance Expiry Date] < TODAY() + 90,"Yes","No")