topic Need help with the if condition for year and month in DAX Commands and Tips

Need help with the if condition for year and month

asdf1608 — Thu, 05 Jan 2023 10:08:36 GMT

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

Re: Need help with the if condition for year and month

amitchandak — Thu, 05 Jan 2023 13:45:50 GMT

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)

Re: Need help with the if condition for year and month

asdf1608 — Thu, 05 Jan 2023 14:18:06 GMT

amitchandak

Thank you so much for your help