Add calculated tables and columns to Power BI Desktop models

  • Module
  • 6 Units
Intermediate
App Maker
Data Analyst
Power BI
Microsoft Power Platform

By the end of this module, you'll be able to add calculated tables and calculated columns to your semantic 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 custom 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