Create Calculated Tables in Power BI

In Power BI, you can create a custom or calculated table from the existing table. This article shows you how to create calculated tables with an example.

To demonstrate these Power BI Calculated Tables, we will use the SQL Data Source we created in Connect to SQL Server article. So, please refer to the same.

Table 1

How to Create Calculated Tables in Power BI

In order to add the calculated table, please click on the New Table option under the Modeling tab.

Choose New Table option in Modeling Tab 2

It will open the Power BI DAX formula bar to write the DAX expression, as shown in the screenshot below.

Create Calculated Tables in Power BI 3

Let me rename the default table name as Countries

Write DAX Query 4

For this Calculated Tables demo purpose, we select Countries from the DimGeography table. As you can see from the screenshot below, Power BI IntelliSense is showing the suggestions while I was typing.

Choosing the Column Names from drop down list 5

From the screenshot below, you can see that we are selecting the DISTINCT (non-duplicates or unique) countries’ names from the Countries column.

Final DAX expression 6

By clicking the enter or any key for that matter will create a new table called Countries holding distinct country names.

Create Calculated Tables in Power BI 7

Let me create a Map using that calculated table that we created earlier.

Map 8