playlistduration

DAX Formulas for Excel Power Pivot & Power BI Desktop

by excelisfun · 57 videos

Total watch time

1d 2h 12m

at 1× speed · exactly 1 day, 2 hours, 11 minutes, 33 seconds at 1×

1×1d 2h 11m 33s
1.25×20h 57m 14s
1.5×17h 27m 42s
1.75×14h 58m 2s
2×13h 5m 47s
Average video27m 34s
Longest2h 31m 36s
Shortest3m 11s
Compare Open on YouTube JSON

Plan to finish

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

Videos (57)

1d 2h 12m in total · tick what you've watched

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

Videos to
Watched
1 DAME 06: DAX Fundamentals in Power BI & Power Pivot: 2.5 Hour Free Class 2:31:36 2024-05-27
2 Excel Data Analysis Class 02: Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More! 1:16:25 2021-04-26
3 Excel Data Analysis Class 03: Power BI Desktop, DAX Formulas, Relationships, Data Modeling& Visuals 1:16:13 2021-05-03
4 Excel Data Analysis Class 04: BIG Data Analysis with Power Pivot & Power BI: Visuals & DAX Formulas 58:02 2021-05-10
5 MSPTDA 15: Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions 2:04:00 2018-11-17
6 MSPTDA 16: Power BI Desktop Comprehensive Introduction: Power Query, DAX, Dashboards, Publishing 1:19:35 2018-12-09
7 MSPTDA 18: DAX Iterators, Table Functions, Grain, Cardinality, Materializing Tables Excel & Power BI 1:07:00 2018-12-30
8 MSPTDA 19: CALCULATE DAX Function & Filter Context & ALLSELECTED & KEEPFILTERS (50 Examples) 1:48:28 2019-02-02
9 Excel 2013 PowerPivot Basics #09: Measures (Calculated Fields) & DAX Functions 9 Examples 29:50 2014-10-26
10 Excel Magic Trick 1403: DAX Formulas: Explicit or Implicit Measures? Why Explicit is Better. 11:22 2017-04-08
11 Excel Magic Trick 1395: DAX Measures for Show Values As % of Grand Total, Column Total, Parent Total 34:41 2017-03-18
12 DAX Approximate Match Lookup & Exact Match Lookup Together for Discounted Product Price (EMT 1490) 20:02 2018-05-06
13 DAX Approximate Match Lookup Part 2: Foreign Key & Relationship or LOOKUPVALUE? EMT1492 13:03 2018-05-08
14 Excel Magic Trick 1398: DAX Formulas for Running Total and % of Running Total & other DAX Tricks 41:14 2017-03-27
15 Excel Magic Trick 1449: DAX Measure % Change MOM & YOY Formulas For Incomplete Years 22:36 2017-07-24
16 Excel Magic Trick 1419: RANKX DAX Function & More: Ranking Profit for Products within Manufacturer 27:06 2017-05-12
17 Excel Magic Trick 1427: DAX GEOMEANX function: Average Compounding Rate per Period for FV Calc 12:14 2017-05-20
18 Excel Magic Trick 1430: DAX Functions XNPV & XIRR for Irregular Cash Flow Net Present Value & IRR 9:45 2017-05-22
19 Power BI Desktop: DAX CALENDAR Function to Create Calendar / Date Table (Excel Magic Trick 1367) 17:40 2017-01-07
20 Excel Magic Trick 1433: Materialize DAX Table Functions: Existing Connections, DAX Studio, Power BI? 20:15 2017-05-24
21 Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP 12:23 2014-08-04
22 Excel Magic Trick 1269: Excel 2016: Without Power Pivot: DAX Measures, Relationships & Data Model 10:09 2016-02-03
23 Excel Magic Trick 1407: Data Model & DAX Measures for Monthly Totals Report From Two Fact Tables 12:46 2017-04-19
24 Excel Magic Trick 1408: DAX Measure: Moving 12 Month Average on Daily Sales (DAX Formatter too) 14:01 2017-04-22
25 Excel Magic Trick 1378: Average of Customer Total Sales by Product: Formulas, DAX or Array Formula? 29:29 2017-02-11
26 Excel Magic Trick 1323: DAX Formula to Pass Many-Side Filter to One Side Aggregate Calculation 5:46 2016-09-14
27 Excel Magic Trick 1424: Average, Moving Average at Different Granularity: DAX or Excel Formulas? 28:07 2017-05-17
28 Excel 2013 PowerPivot Basics #05: Import External Excel Tables, Build Data Model with SUMX function 16:53 2014-10-11
29 Excel Magic Trick 1432: 9 DAX Formulas to Build Confidence Intervals CONFIDENCE.T, STDEV.S… 19:53 2017-05-23
30 Excel Magic Trick 1434: SAMPLE DAX Function to Take Random Stratified Sample from Data Set. 12:12 2017-05-26
31 Excel Magic Trick 1435: DAX Query to Export Data from Data Model to Excel Sheet & Much More! 17:49 2017-05-26
32 Excel Magic Trick 1437: DAX Query OR Logical Test IN Operator: Pull Sales Team Data to Excel Sheet 8:00 2017-05-28
33 Excel Magic Trick 1439: DAX Measures to Create Cross Tabulated OR & AND Logical Test Sales Total 6:52 2017-05-30
34 Excel Magic Trick 1440: OR Logical Test on 2 Columns using DAX IN Operator & DAX OR Function 16:16 2017-05-31
35 Excel Magic Trick 1442 DAX Query & EXCEPT Function to Extract Items In List 1 That Are NOT In List 2 8:54 2017-06-21
36 Excel Magic Trick 1443: DAX Formula for Sales Per Working Day: Power Pivot or Power BI Desktop 21:12 2017-06-23
37 Excel Magic Trick 1447: DAX DISTINCTCOUNT & CONCATENATEX to Count & List Stores Visited 6:20 2017-07-09
38 Excel Magic Trick 1451: Hack Data Model, Date Table & DAX Measures WITHOUT buying Power Pivot 35:56 2017-08-03
39 Excel Magic Trick 1454 DAX Measure Count Customer Totals Between Upper Lower Limits, Each Month 10:30 2017-08-11
40 EMT 1494: DAX & Power Pivot: Allocate Invoice Header Amounts To Invoice Transaction Line Table 23:16 2018-05-14
41 EMT 1496: Power BI Desktop: Allocate Invoice Header Amounts To Transaction Line Item Table 18:47 2018-05-19
42 COUNTIFS in DAX for Power Pivot or Power BI? COUNTROWS Function. Excel Magic Trick 1550 3:11 2019-04-22
43 MSPTDA 22: DAX Data Modeling to Create Date & Time Dimension Tables, Server Downtime Visualizations 20:08 2019-05-08
44 MSPTDA 23: Two Fact Tables? DAX, Power Query or Worksheet Formulas to Convert to 1 Fact Table 1:04:59 2019-05-15
45 MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship 17:28 2019-06-02
46 Running Total in Column, Power Query, DAX or Worksheet Formula? Excel Magic Trick 1553 31:16 2019-06-07
47 MSPTDA 30: Order & Ship Dates in Fact Table: DAX Formulas and Data Modeling to Create Reports 10:19 2019-06-14
48 MSPTDA 31: DAX Studio to Time DAX Average Formulas: AVERAGEX or DISTICTCOUNT? 15:12 2019-06-28
49 DAX Formulas for 1/2 Year Running Totals in Power BI or Power Pivot (Excel Magic Trick 1561) 11:06 2019-07-09
50 DAX Measure & Data Model PivotTable - List Student Classes in Single Cell –- Excel Magic Trick 1607 4:22 2019-09-24
51 DAX Measure & Data Model PivotTable - List Student Classes in Single Cell –- Excel Magic Trick 1607 4:22 2019-09-24
52 MSPTDA 35: Power BI & DAX Formula for Data Modeling with a Slowly Changing Dimensions 10:34 2019-10-26
53 Bring Excel Sheet Variable Into a DAX Measure (Measure Input From Excel Sheet) EMT 1616 5:53 2019-11-03
54 Power Query & DAX Formulas for Advanced Data Modeling to Sort Slicer by PivotTable Values. EMT1678. 11:50 2020-07-11
55 Moving Annual Total with DAX Measure. Excel Magic Trick 1726. 4:50 2021-02-23
56 4 New Create PivotTable Dialog Boxes: 4 Amazing Data Sources. Excel Magic Trick 1729. 7:08 2021-03-16
57 PivotTable Formulas? Calculated Field, DAX Formula or Excel Table Formula for Gross Profit? EMT 1730 12:17 2021-03-23

Embed a badge

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

Watch time: 1d 2h 12m · 57 videos

Markdown
[![Watch time: 1d 2h 12m · 57 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0nglJ9yX2XT5-K1A_AKHpvW.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0nglJ9yX2XT5-K1A_AKHpvW)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0nglJ9yX2XT5-K1A_AKHpvW"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0nglJ9yX2XT5-K1A_AKHpvW.svg" alt="Watch time: 1d 2h 12m · 57 videos" width="221" 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/PLrRPvpgDmw0nglJ9yX2XT5-K1A_AKHpvW 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.