Add DAX calculation groups to Power BI Desktop models

Intermediate
App Maker
Data Analyst
Power BI
Microsoft Power Platform

Occasionally, you might need to add many similar measures to your model. For example, consider that your model includes measures for sales, cost, and profit. You then want to create a report that shows year-to-date (YTD) sales, YTD cost, and YTD profit, in addition to prior year (PY) sales, PY cost, and PY profit. Adding numerous measures can be time-consuming and can clutter the Fields pane with an overwhelming number of fields. Instead of creating each YTD and PY measure, you can quickly add these measures to your model by creating a Data Analysis Expressions (DAX) calculation group.

Learning objectives

In this module, you will:

  • Set up Tabular Editor 2.
  • Create calculations groups.
  • Order calculation items.
  • Set dynamic formatting.
  • Set calculation precedence.
  • Use calculation groups in report layouts.

Prerequisites

  • Experience developing Power BI data models, reports, and dashboards
  • Experience creating calculated tables, calculated columns, and measures by using DAX