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.
Hello, I'm trying to write a code that extracts the number and creates this number in a new column. For example, in the picture below. In column A, I have 058aae, 058rre, etc.. so I want to write a formula that gives me the same result in column B. So the formula allows me to extract a specific value. Sometimes these values can be in anywhere in the sentence. For example, it can be in the beginning or in the middle, or in the end of the sentence. So for example, I want to write a formula that says " IF column A has 058, so then put 058 in column B, and if column A has 300, so then put 300 in column B, etc.
Solved! Go to Solution.
Proud to give back to the community!
Thank You!
When you say 'specfic value' do you only want Numberical Characters from a text field, so your 300trtg00g example would be 30000 instead of 300? Or are you seraching for speicfic numbers in a mix of letter and numbers?
Proud to give back to the community!
Thank You!
No, I'm searching for a specific value. so my 300trtg00g example would be just 300. So for example, I want to write a formula that says " IF column A has 058, so then put 058 in column B, and if column A has 300, so then put 300 in column B, etc.
Check out this tool...
https://www.tutorialspoint.com/dax_functions/dax_search_function.htm
replace the serach text below with your coulmn...
Proud to give back to the community!
Thank You!
Thank you so much. it did work. Do you mind if you can nest further IFs to search for more numbers? because I'm having an issue with that. Thanks for your help
Proud to give back to the community!
Thank You!
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 |