Extract an integer from a text field using DAX - Measure

[NKotak_Leecare]

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

[ryan_mayu]

@NKotak_Leecare 

can we do this in PQ? i think that will be easier

=Text.Select([Column1],{"0".."9"})

[NKotak_Leecare]

@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!