Replacing 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_con... 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: / bigorilla Twitter: / rickmaurinus LinkedIn: / rickmaurinus Thank you for your support! #replacesubstrings #powerquery #m

Jürgen Klopp is the new national coach | Sportschau

Curso: Lenguaje M para POWER QUERY (Introducción a las 7 Reglas de Oro)

Power Query Functions That Unlock Serious Automation

List.Generate in Power Query - Tutorial with Easy Examples

Create a Join based on Date Range in Power Query

Combine Multiple Excel Sheets with a Transform Sample Sheet in Power Query

Promote Multi-Row Headers with One Custom Function in Power Query M

Why I Stopped Relying on Power Query UI

Transform Column Names in Bulk in Power Query

Excel vs Power BI vs SQL vs Python | Restaurant Price History Lookup

Mimic a SWITCH function in Power Query using Record.FieldOrDefault

Reduce Steps in Power Query - Tips Only the Pros Know!

Custom Comparer Function for Table.Group in Power Query M

Cut Your Power Query Steps in Half (With These Tricks ⚡)

Understanding Metadata in Power Query M

Power Query was HARD until I learned these 7 Tips

Power Query - Advanced Transformation of Nested Tables

APQ08: Power Query List Functions - Bulk Replace values in a table using a helper table

CHOSEN ONE! SOMEONE IN A SUIT JUST ASKED "WHO TRAINED THEM?" ...NOBODY DID. THAT'S THE MYSTERY

