Convert code to Power Query

[alice11987]

Hi, I would like to replicate the similar conditional column in Power Query, How should I do it?

IF(
Attribute("Spend Category") !=null 
   && Attribute("Spend Category").Substring(0,2).In(
[
"ZZ"
]
),
"No",
"Yes"
)

Thank you

[AllisonKennedy]

@alice11987  What are you wanting to acheive in English? I'm not familiar with the code you've posted, but if I understand it correctly I agree with @johnyip 

In Power Query, click Add Column > Custom Column , and then paste this code:

if Text.Contains(Text.Start([Spend Category], 2), "ZZ") and [Spend Category] <> null then "No" else "Yes"

If you have a list of other things that you need to include (not just "ZZ"), then try: 

if List.Contains( {"ZZ", "DD"}, Text.Start([Spend Category], 2)) and [Spend Category] <> null then "No" else "Yes"

[johnyip · Accepted solution]

@alice11987 Try the following:

 #"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Custom", each if Text.StartsWith([Spend Category], "ZZ") and Spend Category] <> null  then "No" else "Yes")

where "#Changed Type" should be changed to the appropraite names that your data preparation step is using.