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 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!
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |