Add New Columns in Power BI

AddColumns is a DAX function that is helpful often when writing calculations in Power BI. When adding a calculated column, we must use related data if we are working with more than one table. Let’s see the steps to add a new column in Power BI.

Step 1: You can start by opening the report you want to add a new column into.

Step 2: Click on the name of the report you want to add a new column into, right-click on the name and select the new column option to add a new column. 

Step 3: The next step is to add a new formula in the formula bar about the details to be displayed in the new column to be added. For example, if you want to merge the ‘Name’ and ‘Phone Number’ into one cell. You can add a new column as ‘New Column’ with the formula ‘New Column = [Name] & [Phone Number]’.

Step 4: Once the formula is added, press enters or click on the check mark present next to the formula bar to add the column. The new column will be added in the fields pane on the right side of the Screen and you can add it into your report whenever you need it.

Power BI is used for the analyses of all the business-related factors and for calculating different factors which are of prime importance in business running. The data can be stored in separate tables where many columns can be used to represent different data types. In this article, we will learn how to create new columns in your report using Power BI Software.

Here we will discuss 4 types of Adding Columns in Power BI Desktop

• Add New Columns in Power BI
• Add a Custom Column in Power BI
• Adding Column In Virtual Table
• AddColumns DAX Tabular Function