START AT DAX Statement
The START AT keyword is part of the EVALUATE statement and defines the rows to skip before the specified values according to the sort order specified in the ORDER BY section of EVALUATE.
It includes one or more values, up to the number of columns specified in ORDER BY. The values match the position of the corresponding column in ORDER BY.
EVALUATE ALL ( 'Product'[Brand], 'Product'[Color] ) ORDER BY 'Product'[Brand], 'Product'[Color] START AT "Proseware", "Red"
| Brand | Color |
|---|---|
| Proseware | Red |
| Proseware | Silver |
| Proseware | White |
| Southridge Video | Black |
| Southridge Video | Blue |
| Southridge Video | Brown |
| Southridge Video | Gold |
| Southridge Video | Grey |
| Southridge Video | Pink |
| Southridge Video | Red |
| Southridge Video | Silver |
| Southridge Video | White |
| Southridge Video | Yellow |
| Tailspin Toys | Black |
| Tailspin Toys | Blue |
| Tailspin Toys | Gold |
| Tailspin Toys | Green |
| Tailspin Toys | Grey |
| Tailspin Toys | Pink |
| Tailspin Toys | Purple |
| Tailspin Toys | Red |
| Tailspin Toys | Silver |
| Tailspin Toys | White |
| Tailspin Toys | Yellow |
| The Phone Company | Black |
| The Phone Company | Gold |
| The Phone Company | Grey |
| The Phone Company | Pink |
| The Phone Company | Silver |
| The Phone Company | White |
| Wide World Importers | Black |
| Wide World Importers | Blue |
| Wide World Importers | Brown |
| Wide World Importers | Green |
| Wide World Importers | Grey |
| Wide World Importers | Orange |
| Wide World Importers | Pink |
| Wide World Importers | Purple |
| Wide World Importers | Red |
| Wide World Importers | Silver |
| Wide World Importers | White |
| Wide World Importers | Yellow |
Last update: Aug 18, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
2018-2024 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies