ROW DAX Function (Table manipulation)
Returns a single row table with new columns specified by the DAX expressions.
Syntax
Parameter | Attributes | Description |
---|---|---|
Name | Repeatable |
Name of the new column. |
Expression | Repeatable |
The expression for the column. |
Return values
A single row table.
Remarks
ROW does not preserve the data lineage of the returned columns returned, even though a column expression is a simple column reference.
Examples
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] ) }
Related articles
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
Last update: Feb 25, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/row-function-dax