Aggregation Functions

Mastering DAX Calculations

Introduction to DAX

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

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

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

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

Lecture content locked

If you're already enrolled, you'll need to login.