Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I've found this solution but it didn't work for my case:
try Number.FromText([Text]) otherwise null
I've got a column that is build on alphanumeric characters. (SVF-11254, svf685, SVF742, ....) now I only need the number and nothing else to get the connection with another table right.
I can't use (I think) the delimiter because there are some numbers with 3, 4 or 5 numbers.
With the solution of the 'try number.....' I also get null values for SVF9294 which need to be 9294
Thanks for the help!
Solved! Go to Solution.
Hi @jorismo !
Please try creating a new Column from example in Power Query Editor;
In the new column example type only Integer values for the column, you need to provide 3/4 example value and it will generate M Code to create the new column containing only integer values.
Regards,
Hasham
Hi @jorismo !
Please try creating a new Column from example in Power Query Editor;
In the new column example type only Integer values for the column, you need to provide 3/4 example value and it will generate M Code to create the new column containing only integer values.
Regards,
Hasham
That works, thanks!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |