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 Everyone,
I have a column in my table which contains text and some numeric values. I don't want to see any text in that column, I just want the numeric values in that column.
The text in the column is not the same always, I have more than 1000 different text in the column along with numeric values.
Is there any way to replace all text in the column with "0" and keep numeric values as it is?
It is not efficient to use replace option or conditional column as there are more than 1000 different text and those text in the column might change in the future.
Please suggest if you have any idea.
Solved! Go to Solution.
Hi @Anonymous
Which result are you expecting for the below strings? please kindly elaborate.
Hi @Anonymous
Which result are you expecting for the below strings? please kindly elaborate.
Hi @v-diye-msft ,
Thank you for your response!
Please find the below result that I am expecting for the below strings.
.07/2in (0.07)
.14/trace (0.14)
Trace/0.04 (0)
T/.10.1 (0)
I am getting the "the arguments in generateseries function cannot be blank" error when I am trying the use the above DAX formula you shared. Please let me know if I need to make any changes.
Thank you!
Hi @Anonymous
What's the column [PREC_AMOUNT], make sure the column is in the type of text.
If still not help, kindly upload it here.
@Anonymous may be easy to add a custom column with the following expression and then remove the original column.
try Number.FromText([Column1]) otherwise 0
Would appreciate Kudos 🙂 if my solution helped.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi @parry2k ,
Thank you so much for your response! It worked perfect for text in the columns.
I have Alpha-Numeric values in my column.
If I have alpha-numeric values(For example :- 0.69-MM) in column, I have to just show numeric values(0.69) and remove text(MM) in the column. Is there a way to achieve this?
@Anonymous try this expression in custom column
Text.Select([Column1], {"0".."9"})
Would appreciate Kudos 🙂 if my solution helped. Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi @parry2k ,
Text.Select([Column1], {"0".."9"}) is giving me the below result.
Decimal numbers are now converted to whole numbers. I wanted to see it as decimal numbers.
I do not want to see anything after delimeters(-,/,\,(,_). For example If I have 0.33-5.8R or 1/0.09T or 0.2\0 Zero, I Just want to see numeric vaues(0.33, 1, 0.2) before delimeters.
Thank you for your time😊
@Anonymous paste the sample data with various combinations to further tweak the solution, there are tons of combinations here. Don't paste IMAGE just data in table format so that I can copy and paste at my end.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Please find the below sample data
Precipitation |
trace |
Blank |
1%trace |
-- |
0 |
* |
R/S |
.14/trace |
0.03/0.7 |
.07/2in
|
0.5(0.18)
|
0,0002/T |
T |
T/T |
T/.10.1 |
0.17/1.9 |
Tot Age |
0.03/Trace |
Trace/0.04 |
0.006(0.1) |
NA, |
0.9/2.5 snow |
-- |
0.0.0 |
3/0.0.1 |
0..00 |
0.04/mm |
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |