Replace Values step is used so often in Power Query, that it can lead to lots of query steps and slower load times. If you want to achieve the same result with fewer steps, I show you how to do that in two ways to reuse in either Excel or Power BI:
1. Bulk replace when you want to change the entire cell contents
2. Bulk replace when you want to change part of the cell contents from a table.
Example files can be found here: xlconsulting-asia.com/youtube-files
- Power Query: Bulk Replace Values from a table in Excel & Power BI ( Download)
- Replace Values Based on Condition (in a Single Step) in Power Query ( Download)
- Power Query - Bulk Replace Values in One Step 🔄📊 ( Download)
- Bulk Replacements (Replace Multiple Values in a Table at once) in Power Query ( Download)
- Power Query: How to mass replace values based on a list | Excel Off The Grid ( Download)
- Power Query Replace Values the safer way ( Download)
- APQ08: Power Query List Functions - Bulk Replace values in a table using a helper table ( Download)
- BULK Replace Values in Power BI / Power Query ( Download)
- Replace multiple values in Power Query in one step ( Download)
- INSANE AMAZING Power Query tip to quickly change data sources in Power BI and Excel ( Download)
- Replace Multiple Column Values in One Step [Power Query Tips & Tricks] ( Download)
- Replace Values in Multiple Columns Based on Condition in Power Query ( Download)
- Replace values faster in Power Query: 4 tips ( Download)
- 34. Find And Replace Values | Power Query Editor ( Download)
- Replace values with values in other column - Power BI ( Download)
