{"id":425,"date":"2023-01-07T17:43:08","date_gmt":"2023-01-07T17:43:08","guid":{"rendered":"https:\/\/monocroft.com\/?p=425"},"modified":"2023-01-07T17:56:05","modified_gmt":"2023-01-07T17:56:05","slug":"extract-numbers-from-a-string-in-power-bi","status":"publish","type":"post","link":"https:\/\/monocroft.com\/extract-numbers-from-a-string-in-power-bi\/","title":{"rendered":"How to Extract Numbers From a String in Power BI"},"content":{"rendered":"\n

Do you wonder how to extract numbers from a string in Power BI? This article explains an easy approach to doing that.<\/p>\n\n\n\n

Follow the step-by-step method and practice while doing that.<\/p>\n\n\n\n

Let’s get started.<\/p>\n\n\n\n

Getting started: How to Extract Numbers From a String in Power BI<\/h2>\n\n\n\n

To start this, open your Power BI Desktop, insert the data you want to work with, and navigate your way through the Power Query Editor. <\/p>\n\n\n\n

Here is a view of my Power Query Editor, where I will extract the numbers from the strings (ab3675ghym, asg5687hyg90<\/strong>, etc.) in the worksheet. <\/p>\n\n\n\n

\"how<\/figure>\n\n\n\n

To do this, select Custom Column<\/strong><\/p>\n\n\n\n

\"how<\/figure>\n\n\n\n

The Custom Column Window<\/h2>\n\n\n\n

The above process automatically takes you to the custom column <\/strong>window (where you will write some formula to extract numbers from the string.<\/p>\n\n\n\n

Features of the custom column window<\/h3>\n\n\n\n