651-905-3729 Microsoft Silver Learning Partner EC Counsel Reseller compTIA Authorized Partner

Introduction to DAX for Power BI Desktop Users - Level 3

2 Days

Description

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. Topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with complex time intelligence calculations.

Upcoming Classes

Virtual Classroom Live
November 25, 2024

$1,300.00
2 Days    7:00 AM PST - 3:00 PM PST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

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
Error Handling

Lesson 3 : Content Control Functions

Iterative Functions
The FILTER Function
The ALL Function
The 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

 

Upcoming Classes

Virtual Classroom Live
November 25, 2024

$1,300.00
2 Days    7:00 AM PST - 3:00 PM PST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

Data Model Design using Power BI Desktop – Level 2

Upcoming Classes

Virtual Classroom Live
November 25, 2024

$1,300.00
2 Days    7:00 AM PST - 3:00 PM PST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Comments

This is Part 3 of a 3 Part Exclusive Power BI Cloud Learning Series

Part 1 Report Builder
Part 2 Data Model Designer

For small to large group training

  • Phone: 651-905-3729

Upcoming Classes

Virtual Classroom Live
November 25, 2024

$1,300.00
2 Days    7:00 AM PST - 3:00 PM PST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date