Introduction to DAX for Power BI Desktop Users – Level 3

Description

Overview:

This course takes an in-depth approach to the DAX language, teaching designers how to extend the capabilities of data models for more in-depth, customized business intelligence solutions. Topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with time-intelligence calculations.

Prerequisite(s):

Data Model Design using Power BI Desktop – Level 2

Audience:

Outline:

Lesson 1: Basic DAX Functionality

• Review of Calculated Columns
• Review of Measures
• Rules of Evaluation
• Evaluation Context
• Quick Measures

Lesson 2: Controlling Content & Values

• Controlling Values
• Error Handling

Lesson 3: Content Control Functions

• Iterative Functions
• The FILTER Function
• The ALL Function
• The CALCULATE Function
• Additional All Functions

Lesson 4: Contexts In Relationships

• Working With Many Tables
• Row Context & Relationships
• Elevated Calculated Columns
• Filter Context & Relationships
• Cross Filtering Issues

Lesson 5: Time Intelligence Functions

• Calculating Operating Periods
• To-Date Functions
• Controlling Totals
• Advanced Date Functions
• Prior Year Functions