In Power BI, you can create a custom table (calculated table) from the existing table. In this article, we will show you, How to create calculated tables in Power BI with 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, refer the same.
How to Create Calculated Tables in Power BI
In order to add calculated table, please click on the New Table option under the Modeling tab.
This will open the DAX formula bar as we shown below
Let me rename the default table name as Countries
For the Power BI Calculated Tables demo purpose, we are selecting Countries from DimGeography table. As you can see from the below screenshot, while I was typing, Power BI intellisense is showing the suggestions.
From the below screenshot you can see, we are selecting the DISTINCT (non-duplicates or unique) countries names from Countries column
By clicking the enter, or any key for that matter will create a new table called Countries
Let me create a Map using that calculated table