PQC09 | Flex Filter | M-CODE & User Interface | Power Query Challenge Solution

#powerquery #exceltutorial -------------------------------------------------------------------- Visit the website for more content: www.aaa-power.net -------------------------------------------------------------------- Content: 0:00 Introduction 0:18 Reminder of the challenge 2:36 Solution Plan 8:20 Solution1 (M-Code Functions) 9:11 Record.Filed Function 11:50 Table.ColumnNames Function 14:24 Table.SelectRows Function 15:53 Table.Column Function 17:26 Automating Table.SelectRows 20:23 Optimize the M-Code Solution 22:59 Solution 2 (Merge Queries) 29:15 Wall of Fame 29:32 Close the session -------------------------------------------------------------------- To download the excel files: https://drive.google.com/drive/folders/1hYHpVeogneyN75Fir5TjxdE8_y5wTrkN?usp=drive_link -------------------------------------------------------------------- To watch the full playlist: https://www.aaa-power.net/english/power-query-challenges -------------------------------------------------------------------- To subscribe: https://www.youtube.com/channel/UCAxOgfPN8XqlB-lGmORVB5g?sub_confirmation=1 --------------------------------------------------------------------- To follow on Facebook: https://www.facebook.com/excelispower --------------------------------------------------------------------- To follow on LinkedIn: https://www.linkedin.com/in/amratef