Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
That works. Thanks so much.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |