Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Mastering DAX Calculations
Introduction to DAX
DAX formula reference guide download
What is DAX? (2:54)
How to learn DAX (3:55)
What you can achieve with DAX (3:42)
How to understand DAX (3:51)
Data types and operators (2:39)
Formula syntax (3:11)
The importance of naming conventions (3:40)
Formatting DAX code (4:09)
Writing comments in your code (1:59)
DAX doesn't work unless your data model and relationships are built correctly (3:11)
The only way to learn is to practice on variety of data scenarios (3:46)
Data used in course examples
Bonus demo data for practice
DAX basics
Calculated columns vs measures (4:22)
DAX function types (1:11)
Aggregation Functions (3:44)
Iteration Functions (6:35)
Table functions (7:38)
CALCULATE function (8:05)
DAX patterns (3:25)
Working with one table versus many tables (5:28)
Optimising your data model for DAX
How to build data models so that DAX actually works as expected (5:23)
Lookup Tables vs Fact Tables (2:24)
Getting started with DAX
Understanding context (10:34)
How the DAX calculation engine works (2:32)
Evaluation context (2:40)
Filter context (3:45)
Row context (7:15)
Filter Propagation (2:19)
SUM/AVERAGE/MIN/MAX (3:25)
COUNT/COUNTA/COUNTROWS/COUNTBLANK (3:36)
DIVIDE (2:30)
SUMX/AVERAGEX/MINX/MAXX (7:17)
IF (3:55)
Calculated column examples (7:45)
Expanding on CONTEXT
How Filter and Row context work with relationships (6:23)
ISFILTERED / ISCROSSFILTERED (4:57)
RELATED function (2:32)
CALCULATE statement
Why CALCULATE is important (3:01)
Why do you even have to use CALCULATE? (5:37)
What can you do when you use CALCULATE (5:15)
How are formula calculated when you involve CALCULATE (4:23)
CALCULATE examples (7:56)
Filtering with CALCULATE (4:42)
Understanding context transition (6:50)
Table Functions
FILTER (6:59)
ALL (7:44)
ALLSELECTED (7:26)
ALLEXCEPT (3:34)
VALUES/HASONEVALUE (5:00)
USERELATIONSHIP (6:14)
Common DAX examples
Cumulative totals (12:23)
Averages per day (11:42)
Moving averages (6:29)
Time Intelligence Functions
What are time intelligence functions (2:28)
Why you must have a date table (1:34)
How to set up your data model (1:44)
The importance of CONTEXT and the CALCULATE function (3:27)
Types of time intelligence functions (1:44)
Aggregations - YTD, QTD, MTD (3:05)
Time comparisons - SAMEPERIODLASTYEAR, PARALLELPERIOD, PREVIOUSMONTH (5:56)
Information - OPENINGBALANCEMONTH, STARTOFMONTH, ENDOFYEAR (7:14)
Example of real world situations where you would use time intelligence functions (6:08)
Advanced Table Functions
ADDCOLUMNS (4:43)
SELECTCOLUMNS (2:29)
SUMMARIZE (2:04)
CROSSJOIN (1:23)
Aggregation Functions
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock