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 25,300 courses taught by industry experts.

Create calculated tables or columns

Create calculated tables or columns - 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

Create calculated tables or columns

“

- [Instructor] Okay, so in this sub-lesson we are going to create calculated tables or columns. First off, let's start with calculated tables. Calculated tables let you add new tables based on data you've already loaded into your data model. Instead of querying and loading values into your new tables columns from a data source, you create a data analysis expression, or DAX formula, to define the table's values. Some common DAX functions that are associated with tables are DISTINCT, VALUES, CROSSJOIN, UNION, NATURALINNERJOIN, NATURALLEFTOUTERJOIN, INTERSECT, CALENDAR, and CALENDARAUTO. So let's go up to the Power BI Desktop and take a look. Okay, so I am on the Power BI Desktop now, and what I'm going to do is I'm going to go ahead and build a calculated table. So I'm going to go over to the table view, and let's just take a quick look at the tables we have first before we do anything. So we have a table called Other Country Sales, which contains the country, sales amount, and the year…

Contents