I am trying to use an if statement using YearMonth in relation to a calculated value and cannot get it working.
This is working
if(YearMonth = '2020-02',0,1)
Trying to get something like this to work.
if(YearMonth = Date(AddMonths(max(YearMonth), -6),'YYYY-MM'), 0, 1)
Date(AddMonths(max(YearMonth), -6),'YYYY-MM') outputs 2020-02
Can't figure out why this wouldn't work. Any help is appreciated!