START AT
Introduces a statement that defines the starting value at which the query results of an ORDER BY clause in an EVALUATE statement in a DAX query are returned.
Syntax
[START AT {<value>|<parameter>} [, …]]
Parameters
| Term | Definition |
|---|---|
| value | A constant value. Cannot be an expression. |
| parameter | The name of a parameter in an XMLA statement prefixed with an @ character. |
Remarks
START AT arguments have a one-to-one correspondence with the columns in the ORDER BY statement. There can be as many arguments in the START AT statement as there are in the ORDER BY statement, but not more. The first argument in the START AT statement defines the starting value in column 1 of the ORDER BY columns. The second argument in the START AT statement defines the starting value in column 2 of the ORDER BY columns within the rows that meet the first value for column 1.
To learn more about how START AT statements are used, see DAX queries.
Related content
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for