Create Calculated Tables in Power BI

In Power BI, you can create a custom table or calculated table from the existing table. In this article, we show you how to create calculated tables in Power BI with an example.

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

Create Calculated Tables in Power BI 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.

Create Calculated Tables in Power BI 2

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

Create Calculated Tables in Power BI 3

Let me rename the default table name as Countries

Create Calculated Tables in Power BI 4

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

Create Calculated Tables in Power BI 5

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

Create Calculated Tables in Power BI 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.

Create Calculated Tables in Power BI 8