How to modify expression to return 30 day till 60 day ?

[admin11]

Hi All

I have below expression working fine for from 0 day till 60 day :-

_Deal > Today 60day =

Var _Today =TODAY()

Var _Today_60 = _Today+60

return

IF ('CRM_TS'[Closing Date] >=_Today&&'CRM_TS'[Closing Date] <=_Today_60 , 1, 0)

May i know how to modify the expression , so that it will give from 30 day till 60 day ?

_Deal > Today 30_60day =

Var _Today =TODAY()+30

Var _Today_60 = _Today+60

return

IF ('CRM_TS'[Closing Date] >=_Today&&'CRM_TS'[Closing Date] <=_Today_60 , 1, 0)

Above no error , but return wrong value .

Hope some one can advise me.

Paul

[mahoneypat · Accepted solution]

Since you've already added 30, change your second variable to this.

Var _Today_60 = _Today+30

Pat

[admin11]

@mahoneypat 

it work , many thank