RANGE DAX Function
Retrieves a range of rows within the specified axis, relative to the current row.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Step |
The desired length of the window. If negative, the window will contain the last -STEP rows before the current row. Otherwise, the window will contain the first STEP rows after the current row. |
|
| IncludeCurrent | Optional |
A logical value specifying whether or not to include the current row. Default value is TRUE. |
| Axis | Optional |
An axis reference. |
| Blanks | Optional |
An enumeration that defines how BLANK values are ordered. Valid values are: DEFAULT, LAST, FIRST. |
| 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/range-function-dax