The Advanced DAX course is designed to build on the fundamentals taught in the Introduction to DAX course. This course focuses on the advanced and difficult to comprehend DAX concepts like evaluation context, security, iterator functions, and advanced DAX functions. The goal of this course is to give the student the tools necessary to think like DAX and understand the why behind how calculations work.
Overview
COURSE DIFFICULTY
COURSE DURATION
5h 59m
Skills Learned
After completing this online training course, students will be able to:
Write advanced DAX formulas using CALCULATE and filter context
Implement time intelligence calculations for period comparisons
Configure row-level security using DAX expressions
Use variables to simplify and optimize DAX formulas
Technical Professionals
Introduction to DAX or equivalent experience
01. Class Introduction
02. Working with Variables
03. Working with Filter Context (What is Filter Context?)
04. Working with Filter Context (CALCULATE)
05. Working with Filter Context (FILTER and ALL)
06. Working with Filter Context (ALLEXCEPT)
07. Working with Filter Context (Totals)
08. Time Intelligence (YTD and MTD)
09. Time Intelligence (Rolling Totals)
10. Semi-Additive Measures
11. Semi-Additive Measures (Opening and Closing Balance)
12. Row Context (Understanding Row Context and Context Transition)
13. X Functions
14. Nested Row Context
15. Error Handling
16. Security (Basic)
17. Security (Dynamic)
18. Role Playing Dimensions (Multiple Table Import)
19. Role Playing (USERELATIONSHIP)
20. Advanced DAX Function (CONTAINS)
21. Advanced DAX Function (FIND)
22. Advanced DAX Functions (SEARCH AND SUBSTITUTE)
23. Advanced DAX Function (ALLSELECTED)
24. Advanced DAX Function (RANKX)
25. delete
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Write advanced DAX formulas using CALCULATE and filter context
Implement time intelligence calculations for period comparisons
Configure row-level security using DAX expressions
Use variables to simplify and optimize DAX formulas
WHO SHOULD ATTEND
Technical Professionals
PREREQUISITES
Introduction to DAX or equivalent experience
COURSE OUTLINE
01. Class Introduction
02. Working with Variables
03. Working with Filter Context (What is Filter Context?)
04. Working with Filter Context (CALCULATE)
05. Working with Filter Context (FILTER and ALL)
06. Working with Filter Context (ALLEXCEPT)
07. Working with Filter Context (Totals)
08. Time Intelligence (YTD and MTD)
09. Time Intelligence (Rolling Totals)
10. Semi-Additive Measures
11. Semi-Additive Measures (Opening and Closing Balance)
12. Row Context (Understanding Row Context and Context Transition)
13. X Functions
14. Nested Row Context
15. Error Handling
16. Security (Basic)
17. Security (Dynamic)
18. Role Playing Dimensions (Multiple Table Import)
19. Role Playing (USERELATIONSHIP)
20. Advanced DAX Function (CONTAINS)
21. Advanced DAX Function (FIND)
22. Advanced DAX Functions (SEARCH AND SUBSTITUTE)
23. Advanced DAX Function (ALLSELECTED)
24. Advanced DAX Function (RANKX)
25. delete
