DAX Function Guide

ROW
Empty image or helper icon

Sam McKay

CEO & Founder

How does the ROW 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?

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

Loading

Considerations when using the ROW?

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

Loading

Formula examples using the ROW

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 Courses

Loading