From the course: Power BI Data Analyst Associate (PL-300) Cert Prep: Create Model Calculations Using DAX

Unlock the full course today

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

Demo: Calculated tables

Demo: Calculated tables - Power BI Tutorial

From the course: Power BI Data Analyst Associate (PL-300) Cert Prep: Create Model Calculations Using DAX

Start my 1-month free trial Buy for my team

Demo: Calculated tables

“

- [Instructor] Calculated tables are created using DAX formulas and built from data already in our model. This is a great option to use if we need to store data in our model. An example of this is creating a day table like we did in a previous video. Here are some things to note about calculated tables. The DAX formulas used for creating calculated tables returns a table object. Calculated tables will increase the size of our dataset. The data in calculated tables will be refreshed based on the source table. In a previous video, we created a data table from existing data in our sales table. Let's create a brand new table from our sales table called all sales. To create a calculated table, in the table tools contextual menu, select new table. In the formula bar, type the new table name. In this case, we're calling it all sales, and after the equal sign, we simply put the name of the table that we want to create the…

Contents