ROW DAX Function (Table manipulation)

Returns a single row table with new columns specified by the DAX expressions.

Syntax

ROW ( <Name>, <Expression> [, <Name>, <Expression> [, … ] ] )

Parameter	Attributes	Description
Name	Repeatable	Name of the new column.
Expression	Repeatable	The expression for the column.

Table An entire table or a table with one or more columns.

A single row table.

ROW does not preserve the data lineage of the returned columns returned, even though a column expression is a simple column reference.

The following expression creates a table with one row and two columns:

ROW ( 
    "Sales Amount", [Sales Amount], 
    "Margin", [Margin] 
)

The same table can be obtained using a table constructor, even though this way the column names cannot be controlled (they are Value1, Value2, …)

{ ( [Sales Amount], [Margin] ) }

Learn more about ROW in the following articles:

Using GENERATE and ROW instead of ADDCOLUMNS in DAX

This article explains how to improve DAX queries using GENERATE and ROW instead of ADDCOLUMNS when you create table expressions. » Read more

Contributors: Alberto Ferrari, Marco Russo