Add calculated tables and columns to Power BI Desktop models

Intermediate
App Maker
Data Analyst
Power BI
Power Platform

By the end of this module, you'll be able to add calculated tables and calculated columns to your data model. You'll also be able to describe row context, which is used to evaluated calculated column formulas. Because it's possible to add columns to a table using Power Query, you'll also learn when it's best to create calculated columns instead of Power Query computed columns.

Learning objectives

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

  • Create calculated tables.
  • Create calculated columns.
  • Identify row context.
  • Determine when to use a calculated column in place of a Power Query custom column.
  • Add a date table to your model by using DAX calculations.

Prerequisites

Experience creating Microsoft Power BI Desktop models and designing Power BI report layouts, and an understanding of how to write Data Analysis Expressions (DAX) formulas