Forum Discussion
Solved
Nested if statement in custom column. And or statement
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"), "...
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,
ibarrau
Super User
Super UserHi, 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,