TOPNSKIP is a DAX function that returns the top N rows after skipping a specified number of rows based on a specified expression.
Syntax
TOPNSKIP(
N_Value,
Skip_Rows_Value,
Table,
[ OrderBy_Expression, ... ],
[ Order, ... ],
Ties
)| Argument | Properties | Description |
|---|---|---|
| N_Value | The number of rows to return. | |
| Skip_Rows_Value | The number of rows to skip. | |
| Table | An expression that defines the table from which rows are to be returned. | |
| OrderBy_Expression | Optional, Repeatable | Expression to be used for sorting the table. |
| Order | Optional, Repeatable | The order to be applied. 0/FALSE/DESC – descending; 1/TRUE/ASC – ascending. |
| Ties | Optional | Function behavior in the event of ties. Skip – ranks that correspond to elements in ties will be skipped; Dense – all elements in a tie are counted as one. |