Power BI power query how to add a new column based on other columns value

[henryzf]

I want to create a new column from Power query that if any other columns contain value "异常"then return value in new column "异常" else "正常". I have used List.ComtainsAny but have error.

[dufoq3]

Hi @henryzf,,

Result

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSkxKfrqn6emOHSmpSjpKiYlJSrE6YFEIPyk5KQUmogBRqABVmZgIkQDKAPkpEEmIGIQNFIUyYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    Ad_Custom = Table.AddColumn(Source, "Custom", each if List.Contains(Record.ToList(_), "异常", (x,y)=> Text.Contains(x,y)) then "异常" else "正常", type text)
in
    Ad_Custom

[henryzf]

Hi dufoq3, I still get error. see below. the 159 is from column ID. 
Expression.Error: We cannot convert the value 159 to type Text.
Details:
Value=159
Type=[Type]

[Anonymous · Accepted solution]

Hi @henryzf 

You only need to make a small modification to @dufoq3 's solution like below

= Table.AddColumn(#"Previous Step", "Custom", each if List.Contains(Record.ToList(_), "异常", (x,y)=> Text.Contains(Text.From(x),y)) then "异常" else "正常", type text)

In addition, here is another approach which is close to your original idea. You should use List.Contains function instead. 

if List.Contains({[Device 1],[Device 2],[Device 3],[Device 4]}, "异常") then "异常" else "正常"

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[henryzf]

finally I go with your List.Contains. it is worked. My original way is use List.ComtainsAny but it failed. Thanks so much for your help.

[PwerQueryKees]

I don't see the full code and I don't see an error. Impossible to help here...