What is Dax?
- Basics of DAX Syntax
- Creating a calculated column
- Creating a calculated measure
- Creating a calculated table
- Differences in evaluation context
- Rules of Evaluation
- Working with variables
- Commenting your code
- Testing your code
Course Outline:
- Implicit measures
- Adding quick measures
- Doing basic math
- Using logic in your calculations
- Aggregating and summarizing data
- Working with DAX data types
WORKING WITH CONTEXT IN THE DATA MODEL
- Context defined
- Data modeling basics
- Introduction to dimensional modeling
- Relationships and their effect on the
evaluation context - Getting data from other tables using
RELATED() and RELATEDTABLE() - Modifying the context using CALCULATED()
- Looking up data without using relationships
PERFORMING MORE ADVANCED CALCULATIONS
- Handling errors gracefully
- Using DAX iterator functions
- Using table manipulation functions
- Troubleshooting your calculations using the
Performance Analyzer and DAX Studio
WORKING WITH TIME
- Performing date calculations
- Working with date tables
- Generating a date table with the
CALENDAR() function - Defining custom operating periods
- YTD, QTD, and MTD calculations
- Customer to-date calculations
- Finding year-over-year change
- Finding moving averages
ENHANCING THE USER EXPERIENCE
- Controlling visibility of your measures
- Using What-if parameters
- Adding banding
- Using DAX to provide row-level security