Menu

Introduction to DAX for Power BI Desktop Users – Level 3

ALL SLI DATES ARE GUARANTEED TO RUN!

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.

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.

Target Audience

Report Builders

Prerequisites

Data Model Design using Power BI Desktop – Level 2

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

Full 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
SLI Main Menu