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