ADDCOLUMNS is DAX aggregation function, used to Adds calculated columns to the given table or table expression.
It’s comes under Table Manipulation DAX Functions category. It will return a table with all its original columns and the added ones.
Syntax:
ADDCOLUMNS(<table>, <name>, <expression>[ <name>, <expression>]…)
Description:
| Sno. | Parameter | Description |
| 1 | table | Table or a DAX expression that returns a table. |
| 2 | name | The name given to the new column. |
| 3 | expression | DAX expression that returns a scalar expression, evaluated for each row of table. |
So, Let’s start with an example, You can download the sample Dataset from below link
DAX function – AddColumns Sample Dataset
Step 1: Go to Modeling tab and click on New Table
Create New Table – Power Bi
Step 2: After that, one DAX formula screen will appears , here we will write DAX formula for ADDCOLUMNS function.
So now, we will multiply ‘Unit Price‘ by 1000 and store into new column ‘TotalPrice‘.
Orders_New = ADDCOLUMNS(Orders, "TotalPrice", Orders[Unit Price]*1000)
Step 3: After that click to commit, it will create new table as name Orders_New and under that table you will see TotalPrice new column, result as below.
ADDCOLUMNS DAX funtion
Refer more DAX functions: DAX Tutorials
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome.