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"), "...
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, 

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,