INSTRUCTOR-LED COURSE

Introduction to DAX for Power BI Desktop Users – Level 3

Download Course Outline

Duration: 2 days

Version: Power BI L3

Price: $1,190.00

Certification:

Exam:

Learning Credits:

ALL DATES GUARANTEED

Check out our full list of training locations and learning formats. Please note that the location you choose may be an Established HD-ILT location with a virtual live instructor.

COURSE DELIVERY OPTIONS

Train face-to-face with the live instructor.

Interact with a live, remote instructor from a specialized, HD-equipped classroom near you.

Attend the live class from the comfort of your home or office.

Register

OVERVIEW

This course takes an in-depth approach to the DAX language, teaching designers how to build models that extend the capabilities of source data for more in-depth, customized business intelligence solutions.

Additional Course Information

Prerequisites:

Data Model Design using Power BI Desktop – Level 2

Target Audience:

Report Builders

Course Objectives:

Proper understanding of DAX evaluation
Controlling evaluation context
Understanding relational functions
Error handling within the data model
Working with complex time intelligence calculations

Course Outline:

Lesson 1: Basic DAX Functionality

Review of Calculated Columns
Review of Measures
Rules of Evaluation
Evaluation Context
Formatting DAX Code

Lesson 2: Controlling Content & Values

Controlling Values – DAX
M Language Custom Functions
Error Handling

Lesson 3: Content Control Functions

Iterative Functions
FILTER Function
ALL Function
CALCULATE Function

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

Lesson 6: Appendix – Power BI Functions M Language

Lesson 7: Appendix – Advanced Concepts