How to extract only numbers from text in power bi?
I have the below table, and I need to create a new caclulated column to keep only numbers from string?
To remove all characters and show only numbers in a string in Power BI, you should do the following:
At the Home tab, click on "Edit Queries".
Power Query Editor
At the Add column tab, click on Custom Column.
Write the below formula based on your column name.
You can use Text.Select() to extract only numbers from a string in Power BI
Also, You can use Text.Remove() to extract only numbers from a string in Power BI
Most popular tags