Forum Discussion

NKotak_Leecare's avatar
NKotak_Leecare
Helper III
3 years ago

Extract an integer from a text field using DAX - Measure

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

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

    • NKotak_Leecare's avatar
      NKotak_Leecare
      Helper III
      3 years ago

      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!