Power BI DAX Functions – Level 2

Power BI Desktop Visualizing Data

Creating Measures and KPIs

Course Length: 1 Day
Course Format: Instructor–Led
Course Hours: 9:00 a.m. – 5:00 p.m.

Back to class dates and registration.
Download a PDF of the course outline.

If seeking CPE Credit Hours, completion of this course earns:
8 CPE Credit Hours

Course Description

Course Overview: DAX Functions are an essential part of getting the most out of Power BI. They can make asking complicated questions about your data easy.

Target Student: This course is for students who are part of the data modeling team for their organization. This course is for active learners who need to write the calculations to answer their organization’s questions.

Prerequisites: To ensure your success, we recommend you first take the following CompuTrain courses or have equivalent knowledge: Microsoft® Power BI® - Boot Camp, or Microsoft® Power BI® DAX Functions -Level 1. Students must bring to class the book entitled Supercharge Power BI book which they received in the Microsoft® Power BI® - Boot Camp class.

Course Objectives

Upon successful completion of this course, students will understand:

  • Incorporate time intelligence functions
  • Understand sophisticated date tables
  • Create tables using DAX
  • Use virtual tables
  • Work with variables
  • Work with multiple fact tables
  • Work with inactive relationships between tables
Course Content
Lesson 1: Incorporating Time Intelligence
  • Creating Moving Averages
  • Removing Last 2 Days
  • Custom Time Intelligence
  • Using Sophisticated Date Tables
Lesson 2: Advanced Filter Functions
  • Creating Advanced Filters
  • Creating Virtual Tables
  • FILTER() function revisited
  • Using CONCATENATEX()
Lesson 3: Creating Tables with DAX
  • Create a calendar Table with DAX
  • Summary Tables using DAX vs. Power Query
Lesson 4: Complex Modeling Issues
  • Working with Disconnected Tables
  • Using and Applying Banding
  • Using Variables
  • Working with Multiple Data (Fact) Tables
  • Using Inactive Relationships in Measures