LAST

LAST is a DAX function that retrieves a value from the last row of an axis in a visual calculation data grid.

Syntax

LAST(
   Expression,
   Axis,
   Blanks,
   Reset
)

Argument	Properties	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.

Return Values

The value of column from the last element of the axis.

Remarks

This function can only be used in a visual calculation.

The following visual calculation returns the sales amount of the last row on ROWS axis, that resets on the lowest parent.

LastInternetSalesAmount = LAST ( [Sum of SalesAmount], ROWS, LowestParent )

The screenshot below shows the visual matrix and the visual calculation expression:

Contribute » | Contributors: Rick de Groot