New column with IF THEN ELSE with OR & AND

[DjDon]

Hi all - trying to fill with a new column using the following formula - shows no initial syntax errors but errors at run time:

if [Status] = "A" or "INTL" or "F"

  and [Status Date] < 04/01/2021

  then "Yes"

else  

 if [Status]  = "T" and

  [Status Date] >= 03/01/2021

then "Yes"

else "No"

Any help would be greatly appreciated...

[HotChilli]

With challenges like this, reduce the query to something simple that works, e.g. if [Status] = "INTL" then "y" else "n"

- then add something in which gets a bit closer to the final version.  If it breaks, investigate that.

[DjDon]

power query i believe

[HotChilli]

power query or dax?