This is a complete index for the Comprehensive Power Pivot course.  To use this index, click on “starts with” character for the term you wish to find and the accordion tab will expand.  Beneath the “starts with” character you will find an alphabetical list of terms, which video you can find each term in, as well as, what point in the video you can find that particular term.  You can also click on the term to go to the point in the video. If a term appears more than once in the course it is listed once for each reference.

A

Term Course Element (Video) Name Video Location
Active Customers LTD Measure New vs. Existing Customers and Visitors Tracking 1:15
Active Customers Measure New vs. Existing Customers and Visitors Tracking 0:30
Active vs. Inactive USERELATIONSHIP; Finding the top-selling date/product/etc. 3:00
Activity from Old vs New New vs. Existing Customers and Visitors Tracking 0:00
Add to Filter Context The CALCULATE Function 15:25
AddAllSlicersToAllVisiblePivots Macro Diving into the CF Macro, plus Slicer Macros and Bulk Workbook Mod Macros 3:00
Agg Behaviors & Calculate Behavior of Agg Functions & CALCULATE in Calc Columns 0:00
All Calendar Rows Measure Filter Purpose vs. Table Purpose – Part 1 4:45
All Month Number of Days Measure The ALL() Function 7:48
All Month Sales Measure The ALL() Function 1:10
All Product Sales Measure Putting the IF Stuff in Perspective, Introducing Filter Purpose of VALUES 6:30
All Time Sales Measure ALL() "Cousins" 3:00
ALL() The ALL() Function 0:00
ALL() The ALL() Function 1:35
ALL() ALL() With Sematically Equivalent Columns 2:25
ALL() Slicer Negation Using ALL() 0:00
ALL() Slicer Negation Using ALL() 1:10
ALL() Slicer Negation Using ALL() 3:50
ALL() Slicer Negation Using ALL() 5:50
ALL() ALL() "Cousins" 3:00
ALL() Filter Purpose vs. Table Purpose – Part 1  0:00
ALLEXCEPT() ALL() "Cousins" 4:30
AllSelected product sales Measure ALL() "Cousins" 12:00
ALLSELECTED() ALL() "Cousins" 12:00
Alltime DayofWeek Sales Measures ALL() "Cousins" 6:30
Assembly Line The CALCULATE Function 12:38
Assign Macro To Button The Developer Tab. Recording and Running Macros. “Wrapper” Macros 15:15
Assign Measure to Table Working With Multiple Tables - Part 2 0:00
Asymmetric Reporting “Freshness Date,” First Initial Slicer, Named Sets, & Dummy Tables 14:15
Average Call Length Measure Working With Multiple Tables - Part 4 4:40
Average Transaction Size for N Best Customers Measure Multiple Variations on Top N 7:45
Avg Sales Amt Per Order Measure Warmup & Fundamentals 18:50
Avoid Calculated Columns File Club Rules Continued 3:30
Avoid Large Text Columns Putting the Rules Into Perspective, & Large Text Columns 3:00

B

Term Course Element (Video) Name Video Location
Best Selling Date Measure Scenarios -- 1 Slicer Drives Multiple Params and Weighted Avg. Using SUMX 7:30
Budget vs Actuals Working With Multiple Tables - Part 6 0:00
Budget vs Actuals Working With Multiple Tables - Part 7 0:00
Budget vs Actuals Working With Multiple Tables - Part 8 11:45
BudgetedSales Measure Working With Multiple Tables - Part 7 1:00
Burst into Regions Intro to CUBEMEMBER & Some of Its Uses; EX: Detailed “Card” Reports 0:00

C

Term Course Element (Video) Name Video Location
CALCULATE() The CALCULATE Function 0:00
CALCULATE() The CALCULATE Function 4:15
CALCULATE() Calculate Part 2 4:11
CALCULATE() Calculate Part 2 6:30
CALCULATE() Calculate Part 2 11:05
CALCULATE() Calculate Part 3 0:00
CALCULATE() Calculate Part 3 2:05
CALCULATE() Calculate Part 3 21:15
CALCULATE() The ALL() Function 1:10
CALCULATE() The ALL() Function 7:38
CALCULATE() ALL() With Sematically Equivalent Columns 2:25
CALCULATE() Slicer Negation Using ALL() 1:10
CALCULATE() ALL() "Cousins" 3:00
CALCULATE() ALL() "Cousins" 12:00
CALCULATE() Disconnected Slicers – Part 5 and Intro to FILTER() 0:00
CALCULATE() Disconnected Slicers – Part 5 and Intro to FILTER() 3:00
CALCULATE() Disconnected Slicers – Part 6  9:20
CALCULATE() Disconnected Slicers – Part 7 5:00
CALCULATE() Time Intelligence – Part 2 0:45
CALCULATE() Time Intelligence – Part 4 0:00
CALCULATE() Time Intelligence – Part 4 4:00
CALCULATE() Time Intelligence – Part 4 10:30
CALCULATE() Time Intelligence – Part 5 4:35
CALCULATE() Time Intelligence – Part 7 10:15
CALCULATE() Putting the IF Stuff in Perspective, Introducing Filter Purpose of VALUES 1:00
CALCULATE() Putting the IF Stuff in Perspective, Introducing Filter Purpose of VALUES 6:30
Calculated Columns Advanced Calc Column Intro: Row Context and Scalars 0:00
Calendar Over-Run Custom Calendar With Overrun, Helper Columns 4:00
Calendar Table A Tour of the Data 8:20
Calendar Table Time Intelligence – Part 1 0:00
Calendar Table Time Intelligence – Part 1 3:00
Calendar Table Sources Time Intelligence – Part 3 0:00
Capture Slicer Text Intro to CUBEMEMBER & Some of Its Uses; EX: Detailed “Card” Reports 2:00
Chart Type Selector Disconnected Slicers – Part 3 0:30
CLOSINGBALANCE() Time Intelligence – Part 7 6:00
Coca-Cola Metaphor Disconnected Slicers – Part 6 2:50
Complex Same Store Sales “Same Store Sales” 7:33
Conditional Formatting Working With Multiple Tables - Part 5 1:30
Conditional Formatting Working With Multiple Tables - Part 8 19:45
Conditional Formatting Macro Why Use Macros With Power Pivot, What Are They, and a Dazzling Example 6:45
Connecting Custom Calendars Connecting a Custom Calendar, Using With Existing Basic Measures 0:00
Copy/Paste Table into Power Pivot Working With Multiple Tables - Part 6 7:50
Correct Moving Average Denominaor Time Intelligence – Part 6 11:45
Cost of Calls Measure Working With Multiple Tables - Part 4 10:20
Cost of Calls Measure Disconnected Slicers – Part 1 2:10
Cost of Calls Measure Disconnected Slicers – Part 1 13:30
Cost of Goods Based on Per Row Measure Measures vs Calculated Columns 6:45
Cost of Goods Sold Measure Measures vs Calculated Columns 2:33
Cost Per Minute Slicer Disconnected Slicers – Part 1 7:10
COUNTROWS() Warmup & Fundamentals 14:00
COUNTROWS() The ALL() Function 6:25
COUNTROWS() Working With Multiple Tables - Part 1 5:05
COUNTROWS() Working With Multiple Tables - Part 4 4:00
COUNTROWS() Filter Purpose vs. Table Purpose – Part 1  4:45
COUNTROWS() Intro to the VALUES Function 1:45
COUNTROWS() Intro to the VALUES Function 7:30
COUNTX() Gateway to X Factor: MAXX and SUMX 6:30
Create Calendar Table in Excel Time Intelligence – Part 3 6:30
Create Relationship Working With Multiple Tables - Part 4 2:20
Creation Relationship A Tour of the Data 3:55
Cross Slicer Filtering The Sneaky Impact of Slicers, Plus Bonus Tips 0:00
Cube Formulas Weaknesses Intro to CUBEMEMBER & Some of Its Uses; EX: Detailed “Card” Reports 4:45
CUBEMEMBER() Adding a Slicer to CUBEVALUE & Building a Pure “Scorecard-Shaped” Report 0:00
CUBERANKEDMEMBER() CUBESET, CUBESETCOUNT, and CUBERANKEDMEMBER 6:15
CUBESET() “Bursting” With CUBEMEMBER & Three Limitations of Cube Formulas 3:15
CUBESETCOUNT() “Bursting” With CUBEMEMBER & Three Limitations of Cube Formulas 5:30
CUBEVALUE() Converting a Pivot to Formulas for Report Shaping & Intro to CUBEVALUE 10:00
CUBEVALUE() Converting a Pivot to Formulas for Report Shaping & Intro to CUBEVALUE 0:00
Current Sales - Stores Active Today and Last Yr Measure “Same Store Sales” 6:15
Custom Calandar LTD, YTD and 3-Month MA 0:00
Custom Calendar Guidelines Date Granular Custom Calendars: Guidelines and Fixes 0:00
Custom Calendars Intro to Why We Need Custom Calendars 0:00
Customer Count Measure Intro to the VALUES Function 1:45
Customer First Order Date Ever New vs. Existing Customers and Visitors Tracking 7:00
Customer Rank Dense Ties Measure The Power (and Mystery) of RANKX 4:30
Customer Rank Reverse Order Measure The Power (and Mystery) of RANKX 3:45
Customer Sales Rank Measure The Power (and Mystery) of RANKX 0:30

D

Term Course Element (Video) Name Video Location
Data Loaded Workbook A Tour of the Data 0:10
Data Table A Tour of the Data 6:50
Data Tables Warmup & Fundamentals 7:20
Data Type Error Working With Multiple Tables - Part 7 1:15
Date Axis Control Disconnected Slicers – Part 6  11:30
Date Windows Table Disconnected Slicers – Part 9 4:00
DATEADD() Time Intelligence – Part 5 4:35
DATEADD() Time Intelligence – Part 5 8:15
DATESBETWEEN() Disconnected Slicers – Part 8 0:00
DATESBETWEEN() Disconnected Slicers – Part 9 2:40
DATESBETWEEN() Time Intelligence – Part 4 10:30
DATESBETWEEN() vs FILTER() Disconnected Slicers – Part 8 6:00
DATESINPERIOD() Time Intelligence – Part 6 2:45
DATESINPERIOD() Time Intelligence – Part 6 13:30
DATESINPERIOD() vs DATEADD() Time Intelligence – Part 6 6:00
DATESQTD() Time Intelligence – Part 4 4:00
DATESYTD() Time Intelligence – Part 2 0:45
DATESYTD() Time Intelligence – Part 2 4:00
DATESYTD() Time Intelligence – Part 4 0:00
DATESYTD() Filter Purpose vs. Table Purpose – Part 1  17:00
DAX Error Disconnected Slicers – Part 5 and Intro to FILTER() 3:00
Days Sold Measure Working With Multiple Tables - Part 1 3:20
Days Sold via Calendar Measure Working With Multiple Tables - Part 1 5:05
Days Where DayNumOf Week Equals Days Num of Month Measure EARLIER – In Depth 4:45
Developer Tab The Developer Tab. Recording and Running Macros. “Wrapper” Macros 0:00
Diagram View Thinking Like the Formula Engine 15:00
Disconnected Slicers Disconnected Slicers – Part 1 0:00
Disconnected Slicers Recap Disconnected Slicers – Part 10 0:00
Disconnnected Slicers Disconnected Slicers – Part 2 0:00
Disconnnected Table on Rows Disconnected Slicers – Part 2 2:15
DISTINCTCOUNT() Warmup & Fundamentals 16:30
DISTINCTCOUNT() Working With Multiple Tables - Part 1 3:20
DISTINCTCOUNT() Intro to the VALUES Function 2:00
Double Hop Lookup Working With Multiple Tables - Part 6 12:10
Dummy Table “Freshness Date,” First Initial Slicer, Named Sets, & Dummy Tables 4:15
Dynamic Control of Which Measure in on Chart, by Slicer 0:30
Dynamic TopN Display Multiple Variations on Top N 14:00
Dynamic TopN With Cube Functions Multiple Variations on Top N 17:15

E

Term Course Element (Video) Name Video Location
EARLIER() Intro to EARLIER – When It’s Commonly Used & How It Resembles “CURRENTROW” 0:00
EARLIER() EARLIER – In Depth 0:00
Effective Margin Measure VALUES Continued: IF, HASONEVALUE, Row Context 3:00
ENDOFQUARTER() Time Intelligence – Part 7 10:15
Expand [ALL] CUBESET, CUBESETCOUNT, and CUBERANKEDMEMBER 0:00

F

Term Course Element (Video) Name Video Location
Fever, Christopher Walken Calculate Part Two 0:00
Field List Warmup & Fundamentals 1:08
Field on both Row and Slicer ALL() "Cousins" 8:00
Filter Always Subtracts Disconnected Slicers – Part 7 11:00
Filter by Amount Type Calculate Part Two 1:15
Filter by Magnitude Bucket Calculate Part Two 10:00
Filter by Multiple Calculate Part 3 2:30
Filter Context Thinking Like the Formula Engine 8:15
Filter Direction Working With Multiple Tables - Part 2 13:40
Filter Direction Working with Multiple Tables - Part 3 0:00
Filter Purpose vs Table Purpose Filter Purpose vs. Table Purpose – Part 1  0:00
Filter Purpose vs Table Purpose Filter Purpose vs. Table Purpose – Part 2  0:00
Filter Purpose vs Table Purpose Recap of Table vs. Filter Purpose, VALUES Function, and Where We're Headed 3:00
FILTER() Disconnected Slicers – Part 5 and Intro to FILTER() 4:48
FILTER() Disconnected Slicers – Part 6  9:20
FILTER() Disconnected Slicers – Part 7 5:00
FILTER() Filter Purpose vs. Table Purpose – Part 1  9:45
FILTER() Intro to the VALUES Function 7:30
FILTER() EARLIER – In Depth 3:30
Filters Thinking Like the Formula Engine 2:55
Filters Come From Lookup Table Working with Multiple Tables - Part 3 1:40
Filters Flow To All Tables Working With Multiple Tables - Part 5 5:45
Filters from Lookup vs Data Table Working With Multiple Tables - Part 5 3:45
Filters Only Flow Downhill Working With Multiple Tables - Part 1 7:12
Filters Then Math Thinking Like the Formula Engine 5:22
Finding The "Best" USERELATIONSHIP; Finding the top-selling date/product/etc. 11:51
Finding Top Selling Date USERELATIONSHIP; Finding the top-selling date/product/etc. 6:42
First Sales Date Measure Time Intelligence – Part 8 4:45
FIRSTDATE() Disconnected Slicers – Part 6  8:30
FirstMonthInYear Intro to EARLIER – When It’s Commonly Used & How It Resembles “CURRENTROW” 2:15
FIRSTNONBLANK() Disconnected Slicers – Part 3 8:00
FIRSTNONBLANK() Time Intelligence – Part 8 0:00
FIRSTNONBLANK() Intro to CUBEMEMBER & Some of Its Uses; EX: Detailed “Card” Reports 12:00
FIRSTNONBLANK(),LASTNONBREAK() Time Intelligence – Part 8 12:45
FIRSTNONBLANK(),LASTNONBREAK() Time Intelligence – Part 8 15:00
FISCALYTD Sales Measure Time Intelligence – Part 4 0:45
Follow Inactives USERELATIONSHIP; Finding the top-selling date/product/etc. 4:33
Force Cross Slicer Filtering CUBESET, CUBESETCOUNT, and CUBERANKEDMEMBER 4:00
Formatting Calculate Part 3 3:15
Fundamentals Review Thinking Like the Formula Engine 26:15

G

Term Course Element (Video) Name Video Location
Grand Total Cell The ALL() Function 4:05
Granularity Mismatch Working With Multiple Tables - Part 6 0:30

H

Term Course Element (Video) Name Video Location
Harvester Measures Disconnected Slicers – Part 1 8:30
Harvester Measure Disconnected Slicers – Part 3 6:00
Harvester Measure Disconnected Slicers – Part 5 and Intro to FILTER() 2:00
Harvester Measure Disconnected Slicers – Part 6  8:15
Harvester Measure Disconnected Slicers – Part 6 8:30
HASONEVALUE() VALUES Continued: IF, HASONEVALUE, Row Context 11:45
Hidden Column Disconnected Slicers – Part 4 4:00
Hide From Client Tools Working With Multiple Tables - Part 8 17:40
Hide Gridlines and Headers Macro Diving into the CF Macro, plus Slicer Macros and Bulk Workbook Mod Macros 9:45
Households Above 1k Measure Intro to the VALUES Function 7:30
Households Measure Intro to the VALUES Function 2:00
How Databases Work Tour of Tech History: Databases Are Like Record Players. Power Pivot Is Not 0:00
How Veripak Works Tour of Tech History: Databases Are Like Record Players. Power Pivot Is Not 11:15
Hybrid Calendar Building a Custom Calendar That Extends Down to Day Level 0:00
Hybrid Measures Working With Multiple Tables - Part 4 10:00
Hybrid Prior Month Sales 1 Measure Using “Hybrid” Custom Cal. Requires Sm. Mods to Orig. 445 Measure Patterns 2:30
Hybrid Prior Month Sales 2 Measure Using “Hybrid” Custom Cal. Requires Sm. Mods to Orig. 445 Measure Patterns 8:00
Hybrid Prior Month Sales 3 Measure More Fixes, “Level Sensitivity” Importance & Cont’d. Helper Cols Importance 3:30
Hybrid Prior Year Sales Per Day Measure Moving Averages, YTD, Prior Year, and the Helper Columns Driving Them 1:15
Hybrid Sales Per Day 3 Month MA Measure Moving Averages, YTD, Prior Year, and the Helper Columns Driving Them 2:00
Hybrid Sales Per Day Prior Month Measure Moving Averages, YTD, Prior Year, and the Helper Columns Driving Them 1:00
Hybrid Sales YTD Measure Moving Averages, YTD, Prior Year, and the Helper Columns Driving Them 3:30
Hyperlink Converting a Pivot to Formulas for Report Shaping & Intro to CUBEVALUE 8:30

I

Term Course Element (Video) Name Video Location
If Sales Greater Than 500k Measure Putting the IF Stuff in Perspective, Introducing Filter Purpose of VALUES 4:00
IF() VALUES Continued: IF, HASONEVALUE, Row Context 3:00
IF() More Overrun Trimming, Sales/Day, Importance of Granular Custom Cal. Table 1:00
Impact of Compression on Performance Compression, File Size, and Speed – the Link Revealed 0:00
Impact of Filtering Large Tables FILTER() and Other Row Iterators 3:30
Impact of Row Iterators on Performance Compression, File Size, and Speed – the Link Revealed 0:00
Import from Access A Tour of the Data 1:11
Import from CSV Working With Multiple Tables - Part 4 0:00
Inactive Relationships Scenarios -- 1 Slicer Drives Multiple Params and Weighted Avg. Using SUMX 3:00
Incorrect YearMonth Field Disconnected Slicers – Part 3 1:00
Initial vs Calculate Filters Calculate Part 3 9:30
Inventory Functions Time Intelligence – Part 7 0:00
ISBLANK() More Overrun Trimming, Sales/Day, Importance of Granular Custom Cal. Table 1:00
Islands Thinking Like the Formula Engine 4:28
IsWeekend Calculated Column Measures vs Calculated Columns 13:22
IterateWorkbooksInFolder Macro Diving into the CF Macro, plus Slicer Macros and Bulk Workbook Mod Macros 9:45

J

Term Course Element (Video) Name Video Location
Just Bike Sales Measure The CALCULATE Function 6:25
Just Bike Sales Measure Disconnected Slicers – Part 7 8:05
Just Bike Sales Measure Putting the IF Stuff in Perspective, Introducing Filter Purpose of VALUES 1:00
Just Bike Sales Measure - Filter Version Disconnected Slicers – Part 7 9:15

L

Term Course Element (Video) Name Video Location
Lack of Relationships Working With Multiple Tables - Part 8 11:45
Last Refresh Date “Freshness Date,” First Initial Slicer, Named Sets, & Dummy Tables 2:00
Last Sold Date Measure Time Intelligence – Part 8 1:45
Last Year Sales Measure Time Intelligence – Part 5 4:35
LASTDATE() Disconnected Slicers – Part 6  8:15
LASTDATE() Time Intelligence – Part 4 10:30
LASTNONBLANK() Time Intelligence – Part 8 0:00
LASTNONBLANK() Time Intelligence – Part 8 8:15
Level of Pivot Measure More Fixes, “Level Sensitivity” Importance & Cont’d. Helper Cols Importance 7:30
Lookup Table A Tour of the Data 7:10
Lookup Tables Warmup & Fundamentals 7:20
LOOKUPVALUE() Seasonality and Related Background Trend Correction 5:30
LTD Sales Measure Time Intelligence – Part 4 10:30

M

Term Course Element (Video) Name Video Location
Macro Language Reference Two Great Web Resources: MSDN and Search Engines 0:00
Macro Recorder The Developer Tab. Recording and Running Macros. “Wrapper” Macros 1:00
Macros Why Use Macros With Power Pivot, What Are They, and a Dazzling Example 0:00
Magical Measurey Tour Moving Averages, YTD, Prior Year, and the Helper Columns Driving Them 0:00
Many to Many Bridge Table Tackling True Many to Many 16:00
Many to Many Problem Working With Multiple Tables - Part 6 3:16
Many to Many Problem Gateway to Many to Many – Fixing your “Relationship Problems" 0:00
Many to Many Problem Tackling True Many to Many 0:00
Margin Date Window Measure Disconnected Slicers – Part 9 2:40
Margin DatesBetween Version Measure Disconnected Slicers – Part 8 0:00
Margin Sel Date Range Measure Disconnected Slicers – Part 6  9:20
Mark as Data Table Time Intelligence – Part 1 6:50
Masked Problems Working With Multiple Tables - Part 5 6:50
Master Slicers Conditional Format Via Slicer -- Handling Percentile Scenarios 0:00
Math/Counting Comes From Data table Working with Multiple Tables - Part 3 3:00
Max Single Date Sales Measure Workarounds: “All” Returned From Slicer, Mini-Pivot for Cross Filter 1:30
MAX() Disconnected Slicers – Part 3 6:00
MAX() Disconnected Slicers – Part 4 7:15
MaxEffectiveMonthID Custom Calendar With Overrun, Helper Columns 18:30
MAXX() CUBESET, CUBESETCOUNT, and CUBERANKEDMEMBER 1:30
Mdx .Children Operator CUBESET, CUBESETCOUNT, and CUBERANKEDMEMBER 14:00
Measure that Returns Text Intro to CUBEMEMBER & Some of Its Uses; EX: Detailed “Card” Reports 12:00
Measure vs Calculated Column Measures vs Calculated Columns 0:00
Measure vs Calculated Column Summary Measures vs Calculated Columns 17:00
Measures Warmup & Fundamentals 2:05
Melting Ants VALUES Continued: IF, HASONEVALUE, Row Context 2:00
MIN() Disconnected Slicers – Part 4 7:00
Missing Aggregation Function VALUES Continued: IF, HASONEVALUE, Row Context 5:00
Model Sales Rank vs Competition Measure The Power (and Mystery) of RANKX 9:00
ModifySelectedPivot Macro The Developer Tab. Recording and Running Macros. “Wrapper” Macros 9:00
Most Popular Color Measure Adding a Slicer to CUBEVALUE & Building a Pure “Scorecard-Shaped” Report 12:00
MostRecentMonthID Custom Calendar With Overrun, Helper Columns 17:30
Move Columns Into Lookup Tables The First 4 Rules of File Club 4:00
Moving Average Time Intelligence – Part 6 0:00
Multi-Column Relationship Working With Multiple Tables - Part 7 4:15
Multiple Date Columns Conditional Format Via Slicer -- Handling Percentile Scenarios 0:00
Multiple Table Summary Working with Multiple Tables - Part 3 0:00
Multiple Tables Working With Multiple Tables - Part 1 0:00
Multiple Tables Working With Multiple Tables - Part 4 0:00
Multiple Tables Working With Multiple Tables - Part 5 0:00
Multiple Tables Working With Multiple Tables - Part 7 0:00
Multiple Tables Working With Multiple Tables - Part 8 11:45

N

Term Course Element (Video) Name Video Location
Naked Column Recap of Table vs. Filter Purpose, VALUES Function, and Where We're Headed 4:30
Named Sets “Freshness Date,” First Initial Slicer, Named Sets, & Dummy Tables 9:00
Net Margin Post Support Measure Working With Multiple Tables - Part 4 11:40
Net Sales Measure Calculate Part Two 7:00
New Customers This Month Measure New vs. Existing Customers and Visitors Tracking 3:15
New Customers Via First Order Date Measure New vs. Existing Customers and Visitors Tracking 8:00
NoGrandTotals Macro The Developer Tab. Recording and Running Macros. “Wrapper” Macros 3:45
NoGrandTotalsAnywhere Macro The Developer Tab. Recording and Running Macros. “Wrapper” Macros 21:15
Not Equal, <> Calculate Part 3 15:30
Now with Values Measure Putting the IF Stuff in Perspective, Introducing Filter Purpose of VALUES 7:00
Number of Days Measure The ALL() Function 6:25

O

Term Course Element (Video) Name Video Location
OPENINGBALANCE() Time Intelligence – Part 7 8:15
OR() Calculate Part 3 13:35
Order Lines Measure Warmup & Fundamentals 13:50
Orders Measure Warmup & Fundamentals 16:30
Orders per Calendar Day Measure Working With Multiple Tables - Part 2 6:00
Orders per Day Measure Working With Multiple Tables - Part 2 3:15
Othello The CALCULATE Function 0:40
Out of Sync Problem Measures vs Calculated Columns 5:50

P

Term Course Element (Video) Name Video Location
PerRowMargin Calculated Column Measures vs Calculated Columns 4:35
Perspective on File Size Rules Putting the Rules Into Perspective, & Large Text Columns 0:00
Pivot Table Warmup & Fundamentals 1:00
Portability Warmup & Fundamentals 13:25
Portability Calculate Part Two 16:45
Portability Working With Multiple Tables - Part 8 19:20
Portability Time Intelligence – Part 5 0:00
Power View The Power Pivot Versions and How They Differ 7:48
PowerPivot Reflection Working With Multiple Tables - Part 4 13:11
PowerPivot Version Differences The Power Pivot Versions and How They Differ 0:00
Pre-Slice with Single Letter “Freshness Date,” First Initial Slicer, Named Sets, & Dummy Tables 6:30
Preview and Filter A Tour of the Data 1:40
Prior Year Sales Time Intelligence – Part 5 4:35
Prior Year Sales Custom Calendar With Overrun, Helper Columns 0:00
Products Sold Measure Gateway to X Factor: MAXX and SUMX 6:30
Prorated to All Month Sales The ALL() Function 11:25

Q

Term Course Element (Video) Name Video Location
QTD Sales Measure Time Intelligence – Part 4 3:30

R

Term Course Element (Video) Name Video Location
Rand2 Calculated Column Measures vs Calculated Columns 8:50
Random1 Measure Measures vs Calculated Columns 8:01
RANKX() The Power (and Mystery) of RANKX 0:00
Recipe for EARLIER() EARLIER – The Pattern and The Homework; Recap of Calc Column Concepts 0:00
Reference Card Thinking Like the Formula Engine 24:30
RELATED() Working With Multiple Tables - Part 2 10:30
Relationship Warmup & Fundamentals 6:05
Relationship Direction Warmup & Fundamentals 12:25
Relationship May Be Needed Disconnected Slicers – Part 1 14:50
Relationship May Be Needed Error Working With Multiple Tables - Part 7 11:30
Remove Rows of All Blanks Calculate Part Two 15:00
RemoveAllMeasuresFromPivot Macro “Table of Contents” Macro, Macros w/ Inputs & “Remove all Measures” Macro 5:00
Removing Columns The First 4 Rules of File Club 0:00
Rename Table Working With Multiple Tables - Part 4 2:00
Replace Filter In Context The CALCULATE Function 18:25
Requirements Time Intelligence – Part 1 3:00
Row Context VALUES Continued: IF, HASONEVALUE, Row Context 7:45
Row Context Advanced Calc Column Intro: Row Context and Scalars 3:00
Row Context EARLIER – In Depth 0:00
Rules of "File Club" Tour of Tech History: Databases Are Like Record Players. Power Pivot Is Not 23:45

S

Term Course Element (Video) Name Video Location
Sales From Largest Transactions Measure Disconnected Slicers – Part 5 and Intro to FILTER() 0:00
Sales From Largest Transactions Measure Disconnected Slicers – Part 5 and Intro to FILTER() 2:40
Sales From Largest Transactions Measure Putting the IF Stuff in Perspective, Introducing Filter Purpose of VALUES 3:15
Sales If Always Max Week Measure Workarounds: “All” Returned From Slicer, Mini-Pivot for Cross Filter 8:30
Sales Per Day Gateway to X Factor: MAXX and SUMX 11:00
Sales Per Day STDDEV Measure The Four Families of X Functions, and Intro to COUNTX and STDEVX 14:30
Sales to High Value Households Measure Intro to the VALUES Function 13:45
Sales to Nth Best Customer Measure Multiple Variations on Top N 5:00
Sales to Top 100 Customers Measure Multiple Variations on Top N 0:45
Sales to Top N Customers Measure Multiple Variations on Top N 2:30
Sales to Top N Customers Who Also Have Too Many Cars Measure Multiple Variations on Top N 8:30
Sales to Top Quartile of Customers Measure Multiple Variations on Top N 3:45
Sample Workbook A Tour of the Data 0:10
Save As CSV Working With Multiple Tables - Part 8 11:00
Save As CSV Time Intelligence – Part 3 14:00
Scalar Advanced Calc Column Intro: Row Context and Scalars 5:00
Science Fiction and Huge Data Volumes Introduction, 1,000 Miles of Data, and Science Fiction 0:00
Seasonality Seasonality and Related Background Trend Correction 0:00
Selected Call Rate Measure Disconnected Slicers – Part 1 8:40
Selected EndDate Measure Disconnected Slicers – Part 6  8:15
Selected Measure Measure Disconnected Slicers – Part 3 6:00
Selected Sort Id Measure Disconnected Slicers – Part 4 7:00
Selected Sort Measure Disconnected Slicers – Part 4 4:00
Selected Sort Order Multiplier Measure Disconnected Slicers – Part 4 7:15
Selected StartDate Measure Disconnected Slicers – Part 6  8:30
Service Calls Measure Working With Multiple Tables - Part 4 4:00
SetHyperlink Macro “Table of Contents” Macro, Macros w/ Inputs & “Remove all Measures” Macro 4:00
Short Day Name Calculated Column ALL() With Sematically Equivalent Columns 3:42
Show Items With No Data on Rows Disconnected Slicers – Part 7 2:30
Show Values As The ALL() Function 9:53
Simple Same Store Sales “Same Store Sales” 0:00
Slicer Controlled Conditional Formatting Conditional Format Via Slicer -- Handling Percentile Scenarios 0:00
Slicer Macros Diving into the CF Macro, plus Slicer Macros and Bulk Workbook Mod Macros. 2:45
Slicer Negation Slicer Negation Using ALL() 0:00
Slicers As More Than Filter Disconnected Slicers – Part 1 19:30
Sort by Column ALL() With Sematically Equivalent Columns 0:25
Sort by Column Time Intelligence – Part 2 9:00
Start/End Date Slicers Disconnected Slicers – Part 6  5:20
STDDEVX() The Four Families of X Functions, and Intro to COUNTX and STDEVX 10:45
SUM() Warmup & Fundamentals 2:50
SUM() Measures vs Calculated Columns 2:40
SUM() Measures vs Calculated Columns 6:45
SUM() Calculate Part Two 3:30
SUM() Working With Multiple Tables - Part 4 4:15
SUM() Working With Multiple Tables - Part 7 1:00
SUMX() Gateway to X Factor: MAXX and SUMX 9:30
SWITCH() Measures vs Calculated Columns 14:18
SWITCH() Disconnected Slicers – Part 3 6:30
SWITCH() Disconnected Slicers – Part 4 6:00

T

Term Course Element (Video) Name Video Location
T1000 Disconnected Slicers – Part 3 4:00
T1000 Measure Disconnected Slicers – Part 3 6:30
Table Creation Techniques Working With Multiple Tables - Part 8 0:25
Table Creation Techniques Working With Multiple Tables - Part 8 0:30
Table Creation Techniques Working With Multiple Tables - Part 8 2:00
Table Creation Techniques Working With Multiple Tables - Part 8 4:00
Table Creation Techniques Working With Multiple Tables - Part 8 9:00
Table Relationship A Tour of the Data 6:20
Text Measure Disconnected Slicers – Part 3 8:00
Textual Construction of Cube Formulas Adding a Slicer to CUBEVALUE & Building a Pure “Scorecard-Shaped” Report 9:30
Thinking Like The Engine Thinking Like the Formula Engine 0:00
TOCLinks Macro “Table of Contents” Macro, Macros w/ Inputs & “Remove all Measures” Macro 1:00
TOPN() Intro to CUBEMEMBER & Some of Its Uses; EX: Detailed “Card” Reports 12:00
TOPN() Multiple Variations on Top N 0:00
Total Call Minutes Measure Working With Multiple Tables - Part 4 4:15
Total Margin Measure Measures vs Calculated Columns 3:19
Total Refunds Measure Calculate Part Two 6:30
Total Sales Measure Warmup & Fundamentals 2:28
Total Sales Measure Calculate Part Two 4:11
Total Voids Measure Calculate Part Two 7:35
Tour of Advanced Calculated Columns Moving Averages, YTD, Prior Year, and the Helper Columns Driving Them 4:00
Traditional Excel Working With Multiple Tables - Part 4 8:00
Transactions Above 0 Now and Last Yr Measure “Same Store Sales” 3:26
Trim Precision File Club Rules Continued 0:00
Trimmed Calendar Table Time Intelligence – Part 3 12:30
Troubleshooting Thinking Like the Formula Engine 0:58

U

Term Course Element (Video) Name Video Location
Unable to Connect to Vertipaq Error “Same Store Sales” 2:06
Unique Lookup Table Working With Multiple Tables - Part 6 6:50
Units Sold m2m Measure Tackling True Many to Many 19:00
Unpivot Many Columns Into Many Rows The First 4 Rules of File Club 8:00
USERELATIONSHIP() Scenarios -- 1 Slicer Drives Multiple Params and Weighted Avg. Using SUMX 5:00
USERELATIONSHIP() USERELATIONSHIP; Finding the top-selling date/product/etc. 0:00

W

Term Course Element (Video) Name Video Location
Weighted Average Conditional Format Via Slicer -- Handling Percentile Scenarios 6:00
What-If Disconnected Slicers – Part 1 5:30

Y

Term Course Element (Video) Name Video Location
Year Month Navigation With a Custom Calendar 0:00
Year to Date Time Intelligence – Part 2 0:00
YEARFRAC() Time Intelligence – Part 8 6:50
YTD Grand Total Cell Time Intelligence – Part 2 13:00
YTD Sales Measure Time Intelligence – Part 2 0:00

Z

Term Course Element (Video) Name Video Location
Zero vs Blank Calculate Part Two 12:40

Section

Term Course Element (Video) Name Video Location
"Cannot Be Determined In Current Context" Disconnected Slicers – Part 1 9:45
"Sort By" Slicer Disconnected Slicers – Part 4 2:30

%

Term Course Element (Video) Name Video Location
% Growth vs LY Measure Time Intelligence – Part 5 6:50
% Lost on Support Chart Disconnected Slicers – Part 1 1:45
% Lost on Support Measure Disconnected Slicers – Part 1 2:00
% of All Month Days Measure The ALL() Function 10:40
% of All Month Sales Measure The ALL() Function 8:48
% of All Weekday Sales Measure ALL() With Sematically Equivalent Columns 2:25
% of ALLSELECTED Product Sales Measure ALL() "Cousins" 13:15
% of Budget Measure Working With Multiple Tables - Part 7 10:45
% of Sales to Top Quartile Measure Multiple Variations on Top N 4:15
% of Total The ALL() Function 8:30
% of Visual Total ALL() "Cousins" 9:40
% Sales From Bikes Measure The CALCULATE Function 8:30
% Sales from Largeish Transactions Measure Calculate Part Two 14:00

3

Term Course Element (Video) Name Video Location
3 Month Moving Average Measure Time Intelligence – Part 6 10:45
3 Month Moving Sum Measure Time Intelligence – Part 6 2:45
32-bit / 64-bit The Power Pivot Versions and How They Differ 9:45

4

Term Course Element (Video) Name Video Location
445 3 Month MA Measure LTD, YTD and 3-Month MA 5:30
445 Days in Period Measure More Overrun Trimming, Sales/Day, Importance of Granular Custom Cal. Table 5:00
445 Prior Month Sales Measure Navigation With a Custom Calendar 2:00
445 Prior Qtr Sales Measure Navigation With a Custom Calendar 6:00
445 Prior Year Sales Measure Navigation With a Custom Calendar 6:15
445 Sales LTD Measure LTD, YTD and 3-Month MA 1:00
445 Sales Per Day Measure More Overrun Trimming, Sales/Day, Importance of Granular Custom Cal. Table 6:30
445 Sales PriorYear Measure Custom Calendar With Overrun, Helper Columns 19:00
445 Sales YTD Measure LTD, YTD and 3-Month MA 2:30
445 Sales YTD Measure Custom Calendar With Overrun, Helper Columns 9:45
445 Sales YTD Measure More Overrun Trimming, Sales/Day, Importance of Granular Custom Cal. Table 0:00