FIRST DAX Function
The First function retrieves a value in the Visual Calculation data grid from the first row of an axis.
Syntax
FIRST ( <Expression> [, <Axis>] [, <Blanks>] [, <Reset>] )
| Parameter | Attributes | Description |
|---|---|---|
| Expression |
The expression to be evaluated. |
|
| Axis | Optional |
An axis reference. |
| Blanks | Optional |
Defines how to handle BLANK OrderBy values. Valid values include: DEFAULT, FIRST, LAST. |
| Reset | Optional |
Specifies how the calculation restarts. Valid values are: None, LowestParent, HighestParent, or an integer. |
Last update: Nov 14, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://learn.microsoft.com/en-us/dax/first-function-dax
2018-2024 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies