Download Start File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/036-MSPTDA-SampleFileParameterForCustomFunction-Start.xlsx
Download Finished File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/036-MSPTDA-SampleFileParameterForCustomFunction-Finished.xlsx
In this video learn about how to create a custom Function to transform 12 Cross Tabulated Tables in the Current Workbook to a single Proper Data Set and a PivotTable Report. This video answers the question: How to build Sample File Parameter for a Custom Function.
Topics:
1. (00:01) Introduction
2. (01:38) Get Sheets into Power Query.
3. (04:20) Create Sample Sheet
4. (05:00) Create Parameter
5. (06:45) Create Query with Function M Code Based on Parameter. Lots of Transformation Steps.
6. (10:06) Create Custom Function
7. (10:37) Use Custom Function and Finish Final Query.
8. (11:35) Create Report
9. (11:52) Edit Custom Function
10. (12:50) Summary
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.