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
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
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]))
Related Course Modules
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.