Playlist Duration

Playlist · excelisfun

Power Query Custom Functions: How to Build Power Query Functions Playlist of Videos

by excelisfun · 22 videos

Total watch time

9h 59m

at 1× speed · exactly 9 hours, 58 minutes, 35 seconds at 1×

At an hour a day you'd finish in 10 days

The shape of the course

Each column is one video, to scale

1:50:07

WatchedTo watch

Compare Open on YouTube JSON

Next time, skip the copying: change youtube.com to playlistduration.com in any playlist, video or channel address and it opens here. Or see the total on YouTube itself, with our extension for Chrome, Firefox or Edge.

Your plan

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.

Days

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. Titles open on YouTube in a new tab.

Videos to
Watched Leave out of the total
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
For your README

Embed a badge

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

Watch time: 9h 59m · 22 videos

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 →

Data from the YouTube Data API as of 2026-11-02 (cached). Private or deleted videos are excluded from totals.