Power Query - Clean & Trim EVERYTHING at Once... Dynamically
Автор: BCTI
Загружено: 2025-02-17
Просмотров: 6107
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)
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
