NorthStar Analytics

HiDocs High-Quality Ghost Documentation Theme

How to Create a Calculated Column in Power BI?

How to create a calculated column in Power BI?

Sometimes the data you analyze does not contain the field required for the desired results. Calculated columns come into play here.

Calculated columns employ Data Analysis Expressions (DAX) formulas for various operations, including defining column values, combining text values from multiple columns, and calculating a numeric value from other values. Assume you have the City and State fields in your data but want a single Location field that includes both. This is precisely why calculated columns exist.

Measures and calculated columns are based on DAX formulas, although their usage differs. Measures are commonly used in the Values field of visualization to calculate results depending on other fields. Calculated columns are used as new Fields in visualizations' row, axis, description, and group fields.

When you construct a simple table visual in Power BI Desktop, and all of the entries have the same value, you can see that there is no relationship.

How to Create a Calculated Column?

A calculated column can be created in Report View in two ways:

  1. Modeling Tab > New Column
  2. In the Fields field, right-click on the table to which you want to add a new column, then select New Column.
New column on report view in Power BI

In a Data View, there are three ways to create a calculated column:

  1. From the table tool tab, choose New column.
  2. In the Fields field, right-click on the table for which you want to add a new column and then choose New Column.
  3. Right-click any column and choose New Column.
New column on report view in Power BI 2

The New column window appears after you complete the preceding steps. The field where we will write the Dax function is opened in this window, and our newly created empty column is added to the last column, which is named Column by default.

Dax Function

We give our Dax Function a name and then tell it what action we want it to take for the new column. When we confirm the operation, we can see that our new column's name has changed and the calculated values have been inserted in the rows.

A Sample

In this example, we name our column Total Units Price because we will find the Total of our Unit Sold column.

After writing the Dax function SUM, which represents the sum, we specify the Column that will be used for calculation.

After confirming the operation, you can see that our column name has been updated, as have the column values.

New column on report view in Power BI 3
Make your business data transparent!
  • Subscribe to a package

    Subscribe and explore the limits of your business with data or thinking to expand your agency value proposition with Google Data Studio dashboards?

  • Request unlimited dashboards

    You can request as many dashbaords you might have and as many revisions as you might need. We create a queue of your tasks, the first tasks that come in are the tasks that we’ll deliver first.

  • Your Data Studio Department

    Optimise your business with complete transparency through dashboards or provide value-added Google Data Studio service to your agency clients.

Make your business transparent

The fastest easy-to-use Google Data Studio dashboards without any recurring cost.