AddColumns DAX Tabular Function

A tabular function in DAX is AddColumns. It denotes that a table, not a value, is returned. Tabular functions must be buried inside other functions or utilized as a table expression before being used directly in a measure. The following syntax is required to use this function:

AddColumns(<table>, <column name1>, <expression1>, <column name2>, <expression2>, ...) 

Table: the table that we want to add columns to it
Name: the name of the newly calculated column.
Expression: the expression of the new calculated column you can add multiple columns using this function.

Step 1: Start the Power BI Desktop and open the report you want to work on.

Step 2: Right-click on the table name on the right side of the screen in the field pane and click on the new measures option to create a new DAX Measure.

Step 3: Enter the formula for the new DAX Measure you want to create which gives details about the information to be created for the new measure. The format for the formula is given above to add a new column.

Step 4: The name or reference of the existing table to which you want to add the columns should be substituted for the table.

Step 5: The names you choose for the new columns should be substituted for column name1, column name2, etc.

Step 6: Substitute the DAX expressions that determine the values for the new columns for expression1, expression2, etc. Existing columns or measures, mathematical operations, logical operations, text concatenation, and other DAX functions can all be used in these statements.

Step 7: Once the formula is written, press enters or click on the checkmark next to the formula tab to create a new DAX Measure.

Step 8: The new DAX Measure will be in the field tab on the right side of the screen, and you can use it as needed. 

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