Efficiently Replace Multiple Substrings in Power Query M 🔧

Need to replace a bunch of different substrings in Power Query but not sure how? In this video, I’ll show you an effective way to handle multiple replacements. I'm one of the authors of 'The Definitive Guide to Power Query M. If you want to improve your M language skills, you can get a copy here: https://geni.us/ODZl8 ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 TIMESTAMPS 00:00 Introduction 01:07 The issue 01:47 Replace Values code 02:18 Setting up List.Accumulate 06:59 Creating a custom function 09:22 Using the custom function 10:14 Dynamic replacement list LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #replacesubstrings #powerquery #m