ROW Function (DAX)

How does the ROW function (DAX) work?

The ROW function (DAX) returns a table with a single row containing values that result from the expressions given to each column.

ROW Formula Syntax

ROW(
     [reference]
)

How do you use the ROW function?

The ROW function returns the row number for a cell or range. For example, =ROW(C3) returns 3, since C3 is the third row in the spreadsheet. When no reference is provided, ROW returns the row number of the cell which contains the formula. If you provide a range as a reference, ROW will return the number of the first row in the range.

Related Blog Posts

Related Support Forum Posts

Hiding Rows for Measure taken in Row
Transform Multiple Row Data Into A Single Row Help Please!
Merging files, trying to get nth rows, and 75th percentile row?

Considerations when using the ROW function

The ROW function syntax has the following arguments:

  • Reference    Optional. The cell or range of cells for which you want the row number.
    • If reference is omitted, it is assumed to be the reference of the cell in which the ROW function appears.
    • If reference is a range of cells, and if ROW is entered as a vertical array, ROW returns the row numbers of reference as a vertical array.
    • Reference cannot refer to multiple areas.

Related Video Tutorials

Formula examples using the ROW function

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

=ROW(C10)

=ROW(B1:G9)

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.