Introduction to DAX for Power BI ISI-1591

Module 1Getting started with DAX

• 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

Module 2Performing basic calculations

• Implicit measures
• Adding quick measures
• Doing basic math
• Using logic in your calculations
• Aggregating and summarizing data
• Working with DAX data types

Module 3Working 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 CALCULATE()
• Looking up data without using relationships

Module 4Performing more advanced calculations

• Handling errors gracefully
• Using DAX iterator functions
• Using table manipulation functions
• Troubleshooting your calculations using the Performance Analyzer and DAX Studio

Module 5Working 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
• Custom to-date calculations
• Finding year-over-year change
• Finding moving averages

Module 6Enhancing the user experience

• Controlling visibility of your measures
• Using What-if parameters
• Adding banding
• Using DAX to provide row-level security