Write DAX formulas for Power BI Desktop models

Intermediate
App Maker
Data Analyst
Power BI
Microsoft Power Platform

In this module, you'll learn how to write DAX formulas to create calculated tables, calculated columns, and measures, which are different types of model calculations. Additionally, you'll learn how to write and format DAX formulas, which consist of expressions that use functions, operators, references to model objects, constants, and variables.

Learning objectives

By the end of this module, you'll be able to:

  • Describe the different DAX calculation types.
  • Write DAX formulas.
  • Describe DAX data types.
  • Work with DAX functions.
  • Use DAX operators.
  • Use DAX variables.

Prerequisites

Experience creating Microsoft Power BI Desktop models and designing Power BI report layouts