Text Contains Query in power query

Hello robinshalabh 

the problem I see with the solution from Payeras_BI  is if you have a column that is formated as text not as any. This would mean, everey value is text and so you will get not the desired result. When you use this formula, it should always work

let 
Check = try Number.From([ColumnB])
in 
if Check[HasError] = true then [ColumnB] else null

Here the complete code example

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcvILUIrViVYyNDIG045gEi4KJk3BpJlSbCwA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ColumnB = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ColumnB", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "ColumnA", each let 
Check = try Number.From([ColumnB])
in 
if Check[HasError] = true then [ColumnB] else null)
in
    #"Added Custom"

transform this

into this