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 am trying to extract an integer from a text field. I have attached screenshots of the values from the text field. Ideally, I would want to have a measure which returns integer for each entry if there is a number/integer present in that row. If it is just text then that can be disregarded and returns nothing?
Please let me know if you have any ideas on how to solve this above issue.
Warm regards,
Nidhi
can we do this in PQ? i think that will be easier
=Text.Select([Column1],{"0".."9"})
Proud to be a Super User!
@ryan_mayu Thank you for your response.
Sorry, I should have explained above itself. What I am after is to have this:
The reason I am trying to create in a measure is to not to add additional column and increase the memory. Measure don't occupy much memory.
Let me know if you have any ideas around that. Would much appreciate it!
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |