PREVIOUS DAX Function
The Previous function retrieves a value in the previous row of an axis in the Visual Calculation data grid.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Expression |
The expression to be evaluated. |
|
| Steps | Optional |
Step becomes the offset value after negation. The value should be greater than or equal to 1. Default is 1. |
| 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. |
Related articles
Learn more about PREVIOUS in the following articles:
-
Introducing VISUAL SHAPE for visual calculations in Power BI
This article introduces the VISUAL SHAPE clause, which defines a hierarchical structure for a table used in visual calculations. » Read more
Last update: Apr 27, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://learn.microsoft.com/en-us/dax/previous-function-dax