Power BITutorials

Learn How to Replace Values in Power Query

1 Mins read

There is a cool feature of Power Query which is known as ‘Replace Values’ feature. As the name suggests, it can replace any value with the new value you provide into your data table. You may go through step by step procedure where our Power Query Training expert has explained the topics in a detailed manner with examples that will help you to understand the concepts better.

Power Query Helps In Replacing Values

To understand this feature in detail, let’s take an example.

We have a data set as shown in the steps below. We need to change the Country of a person as he has shifted from India to the U.S. Instead of changing the entire data table, we can directly make changes in the Power Query as explained in the steps below.

  • Step 1: Select the data for replacing
  • Step 2: Select Replace Values Option
  • Step 3: Insert New Value
  • Step 4: Close & Apply

Step 1: Select the data for replacing

Select the columns of the values you want to replace. Here, we have selected the Country column as we want to replace the value ‘India’ as shown in the picture below.

Step 2: Select Replace Values option

To replace values in Power Query go to –

Transform > Replace Values button > Replace Values option

REPLACING VALUES

Step 3: Insert New Value

After you click on the Replace Values option, a window gets open where you can replace the value that you don’t want to appear in the data table as shown below.

INSERT NEW VALUE

Step 4: Close & Apply

When you click on OK in the Replace Value window, it will change the value ‘India’ to ‘U.S’ as shown in the below picture. To apply all the changes just click on the Close & Apply button.

AFTER REPLACING VALUES
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…