Replace Multiple Values with a Single Value in Excel using List.Accumulate

Power Query Training / M Query: Intermediate
This is a continuation of the first case study. In this video, we try to find multiple values and replace each instance with the same value. We will create a list containing all the values that need to be replaced and create a function to look up the list and replace all values on the list with a specified value.

Part 1 Case Study:

Problem: We have multiple values we need to replace. Instead of creating multiple steps to replace the same value over and over, what can you do?

Power Query and Power BI uses the same type of data transformation techniques. In this video I demonstrate how you can use power query to fully automate this job to make it reusable and sustainable. There are also a few challenges to solve along the way.

Data transformation and data cleansing using Power Query.

Functions Used:
- List.Accumulate(
- Text.ReplaceValue

0:00 Problem
2:00 Remove the original solution
2:55 Creating a List
3:45 List.Accumulate
6:16 Adding to the list

Microsoft Excel Tutorial

#powerquery #powerquerytutorials #exceltutorial