Power Query #10: Custom Function, Mega Custom Column Formula, or Parameter Query?
From excelisfun · · 43 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
Download Zipped folder with files: https://excelisfun.net/files/PowerQuery10Files.zip No pdf files for this video. Free Power Query YouTube class from Mike excelisfun Girvin: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lHaJfr4mjRcOMEYqKKvKBj Buy Mike Girvins Power Query M Code book: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/
In this video, we will use our skills from learning M Code in Powery Query Video #9 to perform advanced M Code Data Transformations to convert multiple CSV files that contain Cross Tabulated Tables into a single Table. We will see three alternatives: Custom Function, Mega Formula in a Custom Column, and a Paramater Query Custom Function. This video is composed of Excel Magic Tricks 1917, 1918, and 1919.
This video has subtitles or audio in these 81 languages:Afrikaans, Albanian, Arabic, Bambara, Bangla, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Chinese, Czech, Danish, Dutch, Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (France), German, German (Germany), Greek, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latin, Latvian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malayalam, Mongolian, Nepali, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Punjabi, Romanian, Russian, Samoan, Sanskrit, Scottish Gaelic, Serbian, Sicilian, Sindhi, Sinhala, Slovak, Slovenian, Somali, Spanish (United States), Swahili, Swedish, Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Turkish, Ukrainian, Urdu, Vietnamese, Welsh, Zulu
Topics: 1. (00:00) Power Query Song 2. (00:07) Introduction to Video 3. (01:17) Download files for this video 4. (01:36) Method 1 (Excel Magic Trick 1917): Create Custom Function to convert multiple CSV files that contain Cross Tabulated Tables into a single Table. 5. (17:20) Method 2 (Excel Magic Trick 1918): Create Mega Formula in a Power Query Custom Column to convert multiple CSV files that contain Cross Tabulated Tables into a single Table. 6. (31:22) Method 3(Excel Magic Trick 1919): Create a Parameter Query Custom Function to convert multiple CSV files that contain Cross Tabulated Tables into a single Table. 7. (42:59) Summary 8. (43:05) Closing
#excel #excel365 #excelisfun #mikegirvin #freeexcellessons #excelformulas #excelfunctions #powerQuery #powerQueryClass #PowerQueryCourse #PowerQueryFreeCourse #Customfunctions #powerQueryCustomfunctions #megaformula #ParameterQuery #powerquerytutorial #powerqueryeditor #advancedexcel advancedpowerQuery