LASTNONBLANK

LASTNONBLANK Returns the last value in the column, column, filtered by the current context, where the expression is not blank.


Syntax

LASTNONBLANK(column,expression)

Parameters

Column – A column expression.

Expression – An expression evaluated for blanks for each value of column.

Return Value

A table containing a single column and single row with the computed last value.


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Time Intelligence Functions / LASTNONBLANK