How to add i more condition "90day" to my expression on Deal > Today

[admin11]

Hi All

I have a field name = Closing Date.

I am able to filter Closing date > today :-

_Deal > Today = IF ('CRM_TS'[Closing Date] >= TODAY(), 1, 0)

Can some one share with me , how to modify the above expression , by adding one more condition For next 90 days :-

I have try below , it does not work :-

_Deal > Today_next90day = IF ('CRM_TS'[Closing Date] >= TODAY() & >90day, 1, 0)

 Paul Yeo

[VahidDM · Accepted solution]

Hi @admin11 

Try this:

_Deal > Today = 
Var _Today =TODAY()
Var _Today_90 = _Today+90
return
IF ('CRM_TS'[Closing Date] >=_Today_90 , 1, 0)

If you want to add 1 for all dates from today to 90 days later, then try this:

_Deal > Today = 
Var _Today =TODAY()
Var _Today_90 = _Today+90
return
IF ('CRM_TS'[Closing Date] >=_Today&&'CRM_TS'[Closing Date] <=_Today_90 , 1, 0)

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/

[admin11]

@VahidDM @truptis 

Thank you both expert for your help. it work fine now

[truptis]

Hi @admin11 ,

Please try this:

_Deal > Today_next90day = IF ('CRM_TS'[Closing Date] >= TODAY() & 'CRM_TS'[Closing Date] >90day, 1, 0)

If it works, please mark it as a solution. Thank you.

Regards,

TruptiS

[admin11]

@truptis 

Thnak you very much for your help.

i Get below error :-

DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.

[truptis]

We need to convert closing date column into a number so that we can see if it falls under 90 days. Try using DATESINPERIODS function. 

Regards,

Truptis