Need help with the if condition for year and month

[asdf1608]

To convert the following tableau calculated field to Power BI Dax, which I faced issue while doing this.

STR(if year(TODAY()) = year([Calender]) and month(TODAY())= MONTH(Calender]]) then 1
elseif year(TODAY()) = year(Calender]) and
(month(TODAY())- MONTH(Calender])) >=0 then 1
elseif year(TODAY())-1 = year(Calender]) and
(month(TODAY())- MONTH(Calender])) < 0 then 1
else 0 end)

Help with this is really appreciated.

Thanks in advance

[amitchandak · Accepted solution]

@asdf1608 ,Assuming calendar is name of date column, a new column like

Switch( True() ,
year(TODAY()) = year([Calender]) && month(TODAY())= MONTH(Calender]]), 1
year(TODAY()) = year(Calender]) && (month(TODAY())- MONTH(Calender])) >=0 ,1
year(TODAY())-1 = year(Calender]) && (month(TODAY())- MONTH(Calender])),1,0)

[asdf1608]

@amitchandak 

Thank you so much for your help