Dynamically expanding specific columns & Optimizing code with nested let -
Join me this Saturday for another Power Query session 🪄
I will show you how I dynamically expand specific columns, and how I use a nested let to process calculations in my example.
Working file here (right click and select download):
https://drive.google.com/drive/folder...
Due to the complexity on this example, I'm also sharing the solved file this time 😊
00:00 Intro
03:33 Overview
13:17 Let’s start creating our query
15:30 Creating a parameter for our file’s path/directory
18:45 The transformation process starts!
28:45 Processing calculations in nested tables
38:00 Expanding tables with Table.Combine
40:00 Expanding tables with Table.ExpandColumn and
44:00 Transforming the hard coded column names to a dynamic list, to use that in Table.ExpandColumn
55:50 Load our final table to Excel
57:18 Let’s optimize our query, by using nested let in our code
1:27:37 Wrap-up
#MSExcel #PowerQuery #SaturdayWithPowerQuery