Create Calculated Columns in Power BI

Microsoft Power BI allows you to create custom columns (or calculated columns) from existing columns. In this section, we show you how to create calculated columns in Power BI with example.

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

Create Calculated Columns in Power BI 1

How to Create Calculated Columns in Power BI

In order to create a calculated column, please click on the New Column option under the Modeling tab.

Create Calculated Columns in Power BI 2

Clicking the New Column tab opens the Power BI DAX formula bar, as we shown below.

Create Calculated Columns in Power BI 3

You can rename this calculated column as per your requirement. Let me rename the column as Profit

Create Calculated Columns in Power BI 4

For this Calculated Columns demo purpose, we select Sales Amount and Total Product Cost from Fact Internet Sales table. As you can see from the screenshot below, while I was typing, Power BI IntelliSense is showing the suggestions.

Create Calculated Columns in Power BI 5

From the screenshot below, you can see, we are calculating the Profit by removing Total Product Cost from Sales Amount. Next, by clicking the enter, a new column called profit created.

Create Calculated Columns in Power BI 6

Let me add the calculated column that we created earlier to the existing Table. Remember, this is the table that we created in the Create Table Report article.

Create Calculated Columns in Power BI 7