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.

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

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

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

Related posts
AlteryxTutorials

Alteryx Hotkeys - Alteryx Keyboard Shortcuts

2 Mins read
Top 50+ Alteryx Shortcuts for Windows. Alteryx is popularly known as a Self-Service Analytics tool. Business users can build their data workflows…
AlteryxTutorials

Step By Step Guide to Learn Alteryx

6 Mins read
Alteryx Learning Path: The growth in technology has resulted in growth in understanding. In today’s world, humans – fellow businessmen know the…
Excel VBA CodeTutorials

VBA Code to Clean the Date Format

1 Mins read
When it is useful? Most of the time the most annoying problem is when the data is taken from ERP or other…

Leave a Reply

Your email address will not be published.