The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
95 | |
80 | |
62 | |
56 |
User | Count |
---|---|
252 | |
121 | |
112 | |
81 | |
70 |