Power Query Custom Functions: How to Build Power Query Functions Playlist of Videos — 9h 59m total, 22 videos

1×	9h 58m 35s
1.25×	7h 58m 52s
1.5×	6h 39m 3s
1.75×	5h 42m 3s
2×	4h 59m 18s

Plan to finish

About 10 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

At one hour a day, every day, this playlist takes about 10 days. Turn on JavaScript to plan around your week.

Videos (22)

9h 59m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.


1	MSPTDA 09 Power Query Complete M Code Introduction: Values, let, Lookup, Functions, Parameters, More	1:07:27	2018-08-20
2	Combine Excel Worksheet Data (Not Excel Tables) Into PivotTable using Power Query (EMT 1626)	18:34	2019-12-13
3	Excel Power Query Remove Blank Rows & Columns in All Excel Files During Import. EMT 1660.	22:22	2020-04-17
4	Power Query M Code Custom Function to Convert 12 Cross Tabulated Data Sheets to PivotTable. EMT 1621	15:43	2019-12-20
5	MSPTDA 36: How To Build Sample File Parameter For A Custom Function to Transform 12 Cross Tab Tables	13:23	2019-12-22
6	Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554	21:48	2019-06-20
7	Excel Magic Trick 1349: Power Query with Input Variables from Excel Sheet to Extract Records	18:02	2016-11-21
8	Running Total in Column, Power Query, DAX or Worksheet Formula? Excel Magic Trick 1553	31:16	2019-06-07
9	MSPTDA 10: Power BI M Code for Moving Annual Total (MAT): Custom Function Power Query Custom Column	29:40	2018-08-28
10	Power Query Running Count Based on Row Condition – Excel Magic Trick 1588	7:25	2019-08-13
11	Excel Magic Trick 1357: Power Query Function to Repeat Clean & Transform Steps for Many Excel Files	18:43	2016-12-10
12	Excel Magic Trick 1347: Power Query Function: Split Master Table into Sub Tables for Each Product	21:05	2016-11-18
13	Formula.Firewall Error in Power Query & Power BI: Rebuild This Data Combination Solved (MSPTDA 9.5)	5:22	2018-08-30
14	Power Query M Code Custom Function for Moving Annual Total. Excel Magic Trick 1725	15:43	2021-02-18
15	Power Query and M Code to Import &Transform Data: 20 Epic Examples! 365 MECS 13	1:49:33	2023-03-02
16	Power Query: Extract City Name from Description with List.Accumulate function Excel Magic Trick 1840	7:46	2023-10-11
17	Power Query Table.Group Function Fifth Argument: Comparer Function: Group without Key. EMT 1856	5:52	2024-03-04
18	DAME 05: Master Power Query M Code & Become a Data Shaping Ninja (The Secret Behind Data Analysis)	1:50:07	2024-05-19
19	Approximate Match Lookup in Power Query: 2 Amazing Functions! Power BI or Excel. EMT 1865	13:32	2024-08-14
20	Power Query: A Cleaner Way to Import & Appends CSV Files The Transformative Power of M Code EMT 1872	13:36	2025-03-03
21	Build Power Query Custom Function: Convert Multiple Csv Cross Tab Tables into Single Table EMT 1917.	18:18	2025-11-23
22	Power Query Custom Function with Parameter to Get & Transform Multiple Csv Files Data. EMT 1919	13:18	2025-12-09

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Markdown

[![Watch time: 9h 59m · 22 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0kuIuvn2rCQI14AthSZ43ca.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0kuIuvn2rCQI14AthSZ43ca)

HTML

<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0kuIuvn2rCQI14AthSZ43ca"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0kuIuvn2rCQI14AthSZ43ca.svg" alt="Watch time: 9h 59m · 22 videos" width="203" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PLrRPvpgDmw0kuIuvn2rCQI14AthSZ43ca returns them as JSON — free, no key. API docs →