Forum Discussion

katkat20's avatar
katkat20
Regular Visitor
6 years ago
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"), "Yes", ""))

 

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

 

Any suggestions would be greatly appreciated.

 

 

 

Need Help
Tips and Tricks
  • ibarrau's avatar
    ibarrau
    6 years ago

    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, 

1 Reply

  • ibarrau's avatar
    ibarrau
    Super User
    6 years ago

    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,