10 Sep Power BI – DAX Calculated Tables

Calculated Columns are virtual columns added to an existing table using Data Analysis Expressions (DAX) formulas. They enable you to:

1. Perform calculations on existing data
2. Create new data points for analysis
3. Enhance data modeling and relationships

Key Features

1. Defined using DAX formulas
2. Added to existing tables
3. Calculated dynamically with data refresh
4. Can be used in visuals, filters, and measures

Use Cases

1. Calculate profit margins
2. Create custom categorizations (e.g., age groups)
3. Extract date parts (e.g., year, month, day)
4. Combine text columns
5. Perform conditional logic

Create calculated tables easily in Power BI by clicking the New Table under the Table Tools. The calculated tables are created and displayed in Report View, Data View, or Model View using this Table Tools feature.

Input File: Create tables inside Power BI
Output Saved as: AMIT DAX Calculate Table.pbix

Let’s say we want to combine 3 tables, then we can achieve this using the calculate tables concept.

Let us first create the tables. We will create two tables displaying the students who got maximum marks in a subject. To create a table, open Power BI and click Enter data. We have created our first table here Coding Students. Click Load:

Create the 2^nd table also in a similar way and name it Management Students. Click Load:

Now, we have two tables:

• Coding Students
• Management Students

Both the tables are now visible:

To combine both tables, go to Table View and click Table Tools. After that, click the New table:

The above also opens the formula bar. Write the following DAX expression in the formula bar to combine both the table:

The new table with the result is named Total Students:

Press CTRL+S to save it. We named it AMIT DAX Calculate Table.pbix.

If you liked the tutorial, spread the word and share the link and our website Studyopedia with others.

For Videos, Join Our YouTube Channel: Join Now

Read More:

• Get Data from Excel in Power BI
• Create a Gauge Chart in Power BI
• Create a Column Chart in Power BI
• Create a card in Power BI
• Format the cards in Power BI
• Update the cards in Power BI
• Create a Table in Power BI
• Format the table in Power BI
• Table Conditional Formatting in Power BI
• Create a Filter in Power BI
• Create a slicer in Power BI
• What is Data Tranformation
• What is DAX
• DAX Calculated Columns
• DAX Measures