LAST DAX Function (Visual calculations)
The Last function retrieves a value in the Visual Calculation data grid from the last row of an axis.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Column |
The column from which to retrieve the value. |
|
| Axis | Optional |
An axis reference. |
| OrderBy | Optional |
Columns that define how each partition is sorted. |
| 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. |
Notes
The visual calculation functions have an axis parameter that is defined in the VISUAL SHAPE query syntax produced by the visual calculation feature in Power BI.
Related articles
Learn more about LAST in the following articles:
-
Using visual calculations to highlight an entire row
Visual calculations can be used efficiently to format visuals. This article presents an interesting technique to highlight a row based solely on the maximum value in the last column. » Read more
Last update: Mar 25, 2026 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://learn.microsoft.com/en-us/dax/last-function-dax