Using DAX to Build Measures in Power BI

Difficulty: Intermediate

Duration: 1 minute and 21 seconds

Students: 126

Rating: 3/5

Augment your Power BI data model with custom DAX measures to improve efficiency and provide better metrics for your users. Power BI comes with an extensive range of built-in functions that assist with many common report scenarios. But sometimes, you'll need to create your own measures where the "out of the box" ones don't do exactly what you want or exhibit unintended behavior. In addition to scenario-specific functions, Power BI has general-purpose functions that you can use in DAX statements to create complex custom measures. This lesson explores the use of specific and general functions with DAX to address several scenarios.

Learning Objectives

DAX overview
Basic statistical measures
Calculate and filter functions
Time Intelligence

Intended Audience

This lesson is for students wanting to learn how to leverage data analysis expressions (DAX) to build better and more powerful reports.

Prerequisites

Familiarity with Power BI Desktop
The Loading Data into Power BI lesson