Buy Dideo Subscription
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.
