Conditional column from: if not a number then ...

[Anonymous]

Hi,

Trying to figure how to do this but no luck so far.

Col1, type text, contain two rows, "K" & "1"

What I want to do is add a column using logic like this: if Col1 not a number then Col1 else null.

I am think I need something like: if (!ParseAsNumber(Col1)) then ...

Suggestions appreciated.

Thanks,

-Wes

[Zubair_Muhammad · Accepted solution]

@Anonymous 

Try this Custom Column in Query Editor

=let mylist=List.RemoveItems(List.Transform({1..126}, each Character.FromNumber(_)),{"0".."9"})
in

if List.Contains(mylist,Text.From([Column1])) then [Column1] else null

[Anonymous]

That works. Thanks so much.