How To Do Multiple Exact Match Text Replacements In Power Query

In this tutorial, Melissa will demonstrate a method on how to perform multiple exact text match replacements. If you’ve ever had this requirement, there’s a fair chance that you’ve performed a series of replace value steps. There are multiple ways to achieve this result, but Melissa will particularly show how to use the M function Record.FieldOrDefault for this specific use case.

***** Video Details *****
00:00 Introduction
00:49 Data set
01:00 Replacements
01:39 Solution

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://www.enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://www.enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #PowerQuery #PowerQueryTutorial