Power BI: How to Extract only numbers from String?
To remove all characters and show only numbers in a string in Power BI, you should do the following:
Steps
At the Home
tab, click on "Edit Queries"
.

- The
Power Query Editor
would be Opened.
- From the left side, Select your table.
At the Add column
tab, click on Custom Column
.

Write the below formula based on your column name.
Using Text.Select()
You can use Text.Select()
to extract only numbers from a string in Power BI
= Text.Select([String],{"0".."9"})

Using Text.Remove()
Also, You can use Text.Remove()
to extract only numbers from a string in Power BI
= Text.Remove([String],{"A".."z"})
Output

Download