NEW! FREE 30 Minutes MS Excel - Working with Dates Course  Watch now 

Power BITutorials

Best Ways to Add Column From Examples in Power Query

1 Mins read

Sometimes we need to transform the text from a huge data table which is not directly possible. But, with Power Query, you can easily do it using Add Column from Examples feature. If you want to learn more tips & tricks then you can check our high rated Power Query Course. This training provides excellent training with high-quality videos and lifetime access.

Add Column From Examples By Power Query

Follow the below steps to add a column from example by power query

Step 1- Select the column on which you want to apply changes

Suppose you have a data table as shown in the below picture where you want to remove the delimiter ‘-‘ from each row and change the case of the text. Then, you have to first select that column for applying changes.

SELECT COLUMN TO APPLY ADD COLUMN FROM EXAMPLES FEATURE

Step 2- Add Column from Examples using From Selection option

To add a new column in Power Query, go to –

Add Column  >  Column From Examples  >  From Selection

SELECT COLUMN TO APPLY ADD COLUMN FROM EXAMPLES FEATURE

Step 3- Make changes to the selected column using Add Column from Examples

Power Query gives you access to edit the column you selected after clicking on the From Selection option of Column From Examples button. You just have to replace the text in the first row as you want and the rest Power Query will do for you! As you can see in the below picture, Power Query generates a preview in the new column and you just have to click on OK if the preview is as per your expectation.

ADD COLUMN FROM EXAMPLES

Step 4- Close & Apply

Click on Close and Apply button after you get the expected result as below.

AFTER ADDING COLUMN FROM EXAMPLES

You can learn more : 

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…