ROWNUMBER DAX Function
Returns the unique rank for the current context within the specified partition sorted by the specified order or on the axis specified.
Syntax
ROWNUMBER ( [<Relation>] [, <OrderBy>] [, <Blanks>] [, <PartitionBy>] [, <MatchBy>] )
| Parameter | Attributes | Description |
|---|---|---|
| Relation | Optional |
A table expression where the RANK is computed. If omitted, OrderBy must be explicitly specified. |
| OrderBy | Optional |
Columns that define how each partition is sorted. If omitted, Relation must be explicitly specified. |
| Blanks | Optional |
Defines how to handle BLANK OrderBy values. Valid values include: KEEP, FIRST, LAST, SKIP. |
| PartitionBy | Optional |
Columns that define how Relation is partitioned. |
| MatchBy | Optional |
Columns that define how the current row is identified. |
Last update: Jun 10, 2023 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://learn.microsoft.com/dax/rownumber-function-dax
2018-2023 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies