Add calculated tables and columns to Power BI Desktop models
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.
Data Analyst
App Maker
Microsoft Power Platform
Power BI
Module 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.
Units
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