Power Query - Clean & Trim EVERYTHING at Once... Dynamically
Learn how to dynamically execute the CLEAN and TRIM functions on an entire table, regardless of the number of columns or the column names. Plus, additional M Code optimization tips and tricks.
File Download Link:
https://www.bcti.com//wp-content/YT_D...
"Unlimited Formulas in 1 Step" - M Code optimization tips:
• Power Query - Unlimited Formulas in 1 Step
00:48 Understanding the CLEAN & TRIM Functions
01:34 Examining the "Traditional" Technique
01:50 Loading the Data into Power Query
02:34 Optimizing the M Code
02:42 Understanding the "Traditional" Issues
03:19 Optimizing the Data Typing Step
06:20 Optimizing the TRIM Function
07:21 Optimizing the CLEAN Function
08:01 Comparing M Code (Before & After)