playlistduration

Allocate from Header Fact Table to Line Item Fact Table: Excel, DAX, Power Query or Power BI?

by excelisfun · 9 videos

Total watch time

2h 31m

at 1× speed · exactly 2 hours, 31 minutes, 20 seconds at 1×

1×2h 31m 20s
1.25×2h 1m 4s
1.5×1h 40m 53s
1.75×1h 26m 29s
2×1h 15m 40s
Average video16m 49s
Longest26m 10s
Shortest1m 49s
Compare Open on YouTube JSON

Plan to finish

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

Videos (9)

2h 31m in total · tick what you've watched

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

Videos to
Watched
1 EMT 1493: Excel Formulas PivotTable: Allocate Invoice Header Amounts To Transaction Line Table 21:40 2018-05-10
2 EMT 1493 Part 2: Excel Array Formulas Allocate Invoice Header Amounts To Transaction Line Table 15:37 2018-05-12
3 EMT 1494: DAX & Power Pivot: Allocate Invoice Header Amounts To Invoice Transaction Line Table 23:16 2018-05-14
4 EMT 1495: Power Query: Allocate Invoice Header Amounts To Transaction Line Item Table 20:38 2018-05-16
5 EMT 1496: Power BI Desktop: Allocate Invoice Header Amounts To Transaction Line Item Table 18:47 2018-05-19
6 EMT 1495 Part 02: Power Query with Group By Rows: Allocate Invoice Amounts To Line Item Table 17:40 2018-05-22
7 EMT 1497: Vote For Your Favorite “Allocate Invoice Header Amounts To Transaction Line Table” 1:49 2018-05-24
8 Power Query Power BI: Transform 2 Fact Tables to Star Schema Data Model (Invoice Data) EMT 1498 26:10 2018-05-28
9 Excel Magic Trick 1503: Free Book Give Away EMT 1493 – 1496 RAND & VLOOKUP Functions 5:43 2018-05-31

Embed a badge

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

Watch time: 2h 31m · 9 videos

Markdown
[![Watch time: 2h 31m · 9 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0lPFzYjORi-pIgVrunNQXqc.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0lPFzYjORi-pIgVrunNQXqc)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0lPFzYjORi-pIgVrunNQXqc"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0lPFzYjORi-pIgVrunNQXqc.svg" alt="Watch time: 2h 31m · 9 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/PLrRPvpgDmw0lPFzYjORi-pIgVrunNQXqc 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.