Forum Discussion

villa1980's avatar
villa1980
Resolver II
2 years ago
Solved

Custom Column in Power Query Editor Nested Statement

Hi all,    I am trying to create a custom column with a nested if statment. I can do the basics however I want to say if Example = "Yes" and Example 2 not in ("A","B","C") then "Good" else "Bad2 ...
Need Help
  • MFelix's avatar
    MFelix
    2 years ago

    Glad it helped.

     

    Don't forget to accept as the solution so that it can help others.

MFelix's avatar
MFelix
Super User
2 years ago

Hi villa1980 ,

 

For this you must use not  and List contains:

if [Example] = "Yes" and not( List.Contains ({"A", "B", "C"}, [Example2])) then "Good" else "Bad"