Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Mastering DAX Calculations
Introduction to DAX
How to get certified for this course?
Course resource pack download
What is DAX & how to learn to master it? (9:17)
Data types and operators (5:17)
The importance of naming conventions (6:05)
Formula syntax (4:51)
Measure groups (4:10)
Formatting DAX code (6:54)
Using variables to simplify formulas (6:00)
Writing comments in your code (3:12)
Quick measure feature (positives vs negatives) (7:53)
DAX doesn't work unless your data model and relationships are setup correctly (7:34)
The only way to learn is to practice (3:55)
DAX basics
Calculated columns vs measures (8:46)
Understanding context & how the DAX calculation engine works (9:27)
Evaluation or initial context (3:52)
Aggregations or filter context (5:50)
Iterations or row context (8:11)
Understand context in calculated columns (context transition) (7:55)
How the data models iterates w/DAX (filter propagation) (4:10)
Review Questions
Review Question Feedback
Getting started with DAX
DAX function types (4:10)
Aggregation Functions - SUM/AVERAGE/MIN/MAX (4:58)
More Aggregators - COUNT/COUNTA/COUNTBLANK/COUNTROWS/DISTINCTCOUNT (6:12)
Iteration Functions - SUMX/AVERAGEX/MINX/MAXX (4:47)
Measure branching methodology (7:47)
How to use combinations of DAX functions (6:45)
Error handling w/DAX - BLANK/ISBLANK/IFERROR (6:16)
Logical Functions - IF / SWITCH (10:56)
DIVIDE function (4:05)
Other Function Types - Information, Text, Conversion, Date & Time, Boolean (5:22)
Introducing Simple Table Functions
What are table functions? (think of virtual tables!) (3:48)
FILTER (10:58)
The versatile VALUES function (12:58)
VALUES vs DISTINCT (4:57)
VALUES vs SELECTEDVALUE (& HASONEVALUE) (6:24)
ALL function - the remove filters function (11:02)
ALL & ALLEXCEPT (9:43)
ALLSELECTED requires a deeper understanding (8:47)
Review Questions
Review Question Feedback
Expanding on CONTEXT
How filter and row context work with relationships (8:34)
Working with one table versus many tables (6:34)
ISFILTERED/ISCROSSFILTERED (6:11)
RELATED function (8:51)
EARLIER function (6:28)
CALCULATE statement
Why CALCULATE is important? (2:18)
Why do you even have to use CALCULATE? (It's all about CONTEXT!) (2:30)
What can you do when you use CALCULATE? (6:50)
How are formula calculated when you involve CALCULATE? (6:43)
CALCULATE example w/USERELATIONSHIP (6:09)
Simple and advanced filters with CALCULATE using FILTER function (7:32)
Time Intelligence Functions
What are time intelligence functions? (3:13)
Why you must have a date table? (3:18)
The best time comparison function - DATEADD (9:25)
DATEADD vs SAMEPERIODLASTYEAR (3:04)
Aggregations - YTD, QTD, MTD (7:45)
Time comparisons - PREVIOUSMONTH, PARALLELPERIOD (6:22)
Information - OPENINGBALANCEMONTH, STARTOFMONTH, ENDOFYEAR (6:47)
DATESBETWEEN, DATESINPERIOD, DATEDIFF functions (9:53)
Practical examples using time intelligence functions (9:34)
Download your PBIX here
Basic Labs Assessment
Review Questions
Review Question Feedback
Advanced Techniques For Variables
Understanding how variables are evaluated (14:42)
Using table variables to simplify ultimate formulas (6:50)
Using variables to clean up multiple measures (5:53)
Creating Virtual Relationships
When to create virtual vs physical relationships? (5:17)
TREATAS (8:40)
How does USERELATIONSHIP compare? (3:38)
Advanced Table Functions
How to manipulate virtual tables using table functions (4:03)
ADDCOLUMNS (8:21)
SUMMARIZE (7:45)
You can also combine table functions together (3:50)
CROSSJOIN (7:45)
ROW (2:50)
UNION (5:21)
CALCULATETABLE (11:35)
INTERSECT & EXCEPT (10:07)
SUMMARIZECOLUMNS (4:26)
GENERATE (3:22)
GROUPBY (7:39)
Review Questions
Ranking Functions
RANKX (8:32)
TOPN (7:08)
Practical examples for using ranking functions (11:00)
Advanced DAX Formula Combination Examples
This is where the measure branching methodology really shines (1:46)
Compare multiple quarterly sales on each other (10:36)
Using virtual tables with COUNTROWS (7:30)
Budgeting allocation algorithm (11:22)
Fixing errors with your totals efficiently (6:03)
Review Questions
Review Question Feedback
Your Feedback
Course Survey
Certification
Certificate & Badge
The best time comparison function - DATEADD
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock