Nested if statement in custom column. And or statement

[katkat20]

I need to create a custom column with a conditional statement.  This is what the statement would look like in Excel:

if(column1 = 1, if(or(column2 = "red", column2= "blue", column2 = "yellow"), "Yes", ""))

But I've not managed to find the equivalent in the query editor yet.

Any suggestions would be greatly appreciated.

[ibarrau · Accepted solution]

Hi, changing between languages can be tricky. It would probable be very similar if you do it on dax. Anyway, let's check this on power query for the query editor.

if [column1] = 1 then 
if ([column2] = "red" or [column2] = "blue" or [column2] = "yellow") then "Yes"
else ""
else ""

I think that would be exactly the condition.

Regards,