From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Use cases for calculated columns and calculated tables

Use cases for calculated columns and calculated tables - Power BI Tutorial

From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Use cases for calculated columns and calculated tables

“

- [Instructor] In this sub-lesson, we are going to identify use cases for calculated columns and calculated tables. Calculated tables in Power BI are incredibly useful when you need to create additional tables from existing data in your data model. They're useful for data transformation, where if you need to transform or reshape data in your model, for example, creating an aggregation or filtering out certain rows. They're useful for deriving data when you want to create new tables based on calculations that combine or manipulate columns and other tables. They're useful for customer relationships, if you need to set up relationships between tables that aren't directly sourced from your data. They're useful for static tables to define tables with fixed values like lookup tables for categories and when comparing regular and calculated tables, regular tables are imported directly from external data sources like databases, spreadsheets, or online services. Whereas calculated tables are…

Contents