Skip to main content
AmigoFish

Power Query Custom Function with Parameter to Get & Transform Multiple Csv Files Data. EMT 1919

From excelisfun · · 13 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.

Watch on YouTube

Not rated yet

Description

Download: 1) Excel File: https://excelisfun.net/files/EMT1917-1919.xlsx 2) Zipped Data Folder: https://excelisfun.net/files/SeattleAirportData.zip Buy excelisfun’s Power Query M Code book: https://www.mrexcel.com/products/the-transformative-magic-of-power-query-m-code-in-excel-and-power-bi/ Buy excelisfun’s other Excel Books: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=ap_rdr&ccs_id=6f8ce877-462f-447e-b825-7ede1f72a9d3 Free Excel Class from excelisfun: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo Learn how to import multiple Csv files that each have a cross tabulated data structure and build a Custom Column Formula to convert each table to a proper table and then append them all into a single table. Learn a lot about M Code in this video. Topics: 1. (00:00) Introduction. 2. (00:36) excelisfun’s Power Query M Code Book. 3. (00:51) Advantage of using a Parameter in a Custom Function. 4. (01:57) Cross Tab data. 5. (02:23) Files to download. 6. (02:35) Goal of Video. 7. (02:42) From Folder feature. 8. (03:26) Create Sample File with Two Way M Code Lookup. 9. (05:31) Create Parameter. 10. (06:10) Create query with code for Custom Function. 11. (08:01) Create Custom Function. 12. (09:30) Use Custom Function in final query. 13. (10:00) Combine tables. 14. (11:02) Edit Custom Function. 15. (11:56) Power of parameter. 16. (12:24) Add files to folder and see if everything updates. 17. (13:00) Summary 18. (13:06) Closing

#excel #microsoft #excelisfun #excelcourse #mikegirvin #excel365 #powerquery #customfunction #powerqueryfunction #powerquerycustomfunction #importmultiplefiles #letexpression #letstatement #mcode #powerquerymcode #importdata #exceldataanalysis #powerbidataanalysis

This video has subtitles or audio translations in these languages: Afrikaans, Amharic, Arabic (experimental), Bangla (experimental), Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Chinese, Chinese (China), Czech, Danish, Dutch, Dutch (Netherlands), Estonian, Faroese, Filipino, Finnish, French, French (France), Georgian, German, German (Germany), Greek, Hebrew (experimental), Hindi, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean (experimental), Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malayalam, Mongolian, Nepali, Norwegian, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Punjabi (experimental), Romanian, Russian (experimental), Sanskrit, Scottish Gaelic, Serbian, Sicilian, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Swahili, Swedish, Tajik, Tamil (experimental), Tatar, Telugu (experimental), Thai, Tibetan, Turkish, Turkmen, Ukrainian, Urdu, Vietnamese, Welsh, Western Frisian, Zulu. Click gear icon below video to set subtitles, audio and language.

Back to excelisfun · Report a problem