Efficiently Replace Multiple Substrings in Power Query M 🔧

Learn a simple and effective method to replace multiple substrings at once in Power Query M. Boost your data transformation skills today!

BI Gorilla7.5K views11:42

🔥 Related Trending Topics

LIVE TRENDS

This video may be related to current global trending topics. Click any trend to explore more videos about what's hot right now!

THIS VIDEO IS TRENDING!

This video is currently trending in South Africa under the topic 'powerball results: friday'.

About this video

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

Video Information

Views
7.5K

Total views since publication

Likes
381

User likes and reactions

Duration
11:42

Video length

Published
Jan 29, 2025

Release date

Quality
hd

Video definition

Tags and Topics

This video is tagged with the following topics. Click any tag to explore more related content and discover similar videos:

Tags help categorize content and make it easier to find related videos. Browse our collection to discover more content in these categories.