topic Re: New column with IF THEN ELSE with OR & AND in DAX Commands and Tips

New column with IF THEN ELSE with OR & AND

DjDon — Fri, 23 Apr 2021 18:38:30 GMT

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 — Fri, 23 Apr 2021 18:43:24 GMT

power query or dax?

DjDon — Fri, 23 Apr 2021 18:45:13 GMT

power query i believe

HotChilli — Fri, 23 Apr 2021 18:55:31 GMT

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.