INSTRUCTOR-LED COURSE

Introduction to DAX for Power BI Desktop Users – Level 3

Course Information

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.

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

  • Power BI Functions: M Language
  • Basic M Language Queries
  • M Language Syntax
  • Adding Columns
  • Duplication & Splitting Columns
  • IF Expression
  • Query Cleanup
  • M Language vs. DAX Functions

Lesson 7: Appendix – Advanced Concepts

  • Additional Uses Of The ALL Function
  • Advanced-Data Tables
  • Working with Missing Periods
  • Working with Non-standard Years
  • Parameter Tables
  • Banding