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

Easy Column Selection for Big Tables in Power Query M (Must Know Hack!)

Power Query Functions That Unlock Serious Automation

Why I Stopped Relying on Power Query UI

SQL Logical Operators: Basic Filtering with AND & OR | The Analytics Flow

Understanding Metadata in Power Query M

Custom Comparer Function for Table.Group in Power Query M

Importing Excel files from a folder: Power Query metadata magic

Nested Table Tricks That Save Hours of Power Query Work

Fast Running Totals in Power Query (Complete Guide)

The Fastest Replace Values method using a list in Power Query

Advanced Unpivoting Tricks in Power Query

Dream Bouquet Painting | Framed Art Screensaver For TV | Minimalistic TV Art

Power Query Secrets - Simple tweaks is all it takes.

Turing Award Winner: Disagreeing with Google, Postgres, Future Problems | Mike Stonebraker

Pink and Orange Aura | Gradient Colours | screensaver | backdrop | LED light | orange pink aura

List.Buffer: This One Power Query Function Can Speed Up Your Refresh

Make your Group By Operations Dynamic in Power Query M

Replace Multiple Values in Power Query

These 5 Custom Column Tricks Make Power Query Easier

