playlistduration

% of Column Totals: Worksheet Formula, PivotTable or Data Model & DAX

by excelisfun · 7 videos

Total watch time

1h 37m

at 1× speed · exactly 1 hour, 37 minutes, 19 seconds at 1×

1×1h 37m 19s
1.25×1h 17m 51s
1.5×1h 4m 53s
1.75×55m 37s
2×48m 40s
Average video13m 54s
Longest34m 41s
Shortest5m 13s
Compare Open on YouTube JSON

Plan to finish

About 2 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 2 days. Turn on JavaScript to plan around your week.

Videos (7)

1h 37m in total · tick what you've watched

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

Videos to
Watched
1 Excel Magic Trick 1395: DAX Measures for Show Values As % of Grand Total, Column Total, Parent Total 34:41 2017-03-18
2 Excel Magic Trick 1394 Part 2: Formulas for % Parent Total using Wild Cards to Get First Text Item 5:13 2017-03-17
3 Excel Magic Trick 1394: Excel Formulas for: % Column Total, % Parent Total, % Parent Row Total 16:33 2017-03-16
4 Excel Magic Trick 1393 PivotTable Show Values As: % Column Total, % Parent Total, % Parent Row Total 7:34 2017-03-14
5 DAX Formulas for 1/2 Year Running Totals in Power BI or Power Pivot (Excel Magic Trick 1561) 11:06 2019-07-09
6 DAX Formulas for 1/2 Year Running Totals in Power BI or Power Pivot (Excel Magic Trick 1561) 11:06 2019-07-09
7 DAX Formulas for 1/2 Year Running Totals in Power BI or Power Pivot (Excel Magic Trick 1561) 11:06 2019-07-09

Embed a badge

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

Watch time: 1h 37m · 7 videos

Markdown
[![Watch time: 1h 37m · 7 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0nn_-3V0RXm6eJ6UUD6RJ_m.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0nn_-3V0RXm6eJ6UUD6RJ_m)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0nn_-3V0RXm6eJ6UUD6RJ_m"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0nn_-3V0RXm6eJ6UUD6RJ_m.svg" alt="Watch time: 1h 37m · 7 videos" width="196" 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/PLrRPvpgDmw0nn_-3V0RXm6eJ6UUD6RJ_m returns them as JSON — free, no key. API docs →

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