Table of contents
TOC
Collapse the table of content
Expand the table of content

ROW Function (DAX)

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

Returns a table with a single row containing values that result from the expressions given to each column.

Syntax

ROW(<name>, <expression>[[,<name>, <expression>]…])  

Parameters

name
The name given to the column, enclosed in double quotes.

expression
Any DAX expression that returns a single scalar value to populate. name.

Return Value

A single row table

Remarks

Arguments must always come in pairs of name and expression.

Example

The following example returns a single row table with the total sales for internet and resellers channels.

ROW("Internet Total Sales (USD)", SUM(InternetSales_USD[SalesAmount_USD]),  
         "Resellers Total Sales (USD)", SUM(ResellerSales_USD[SalesAmount_USD]))  

The code is split in two lines for readability purposes

© 2018 Microsoft