Forum Discussion
Conditional column from: if not a number then ...
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
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
2 Replies
- Zubair_Muhammad
Community Champion
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