LASTNONBLANKVALUE

Applies to: Calculated column Calculated table Measure Visual calculation

Note

This function is discouraged for use in visual calculations as it likely returns meaningless results.

Evaluates an expression filtered by the sorted values of a column and returns the last value of the expression that is not blank.

Syntax

DAX

LASTNONBLANKVALUE(<column>, <expression>)

Term	Definition
`column`	A column or an expression that returns a single-column table.
`expression`	An expression evaluated for each value of `column`.

The last non-blank value of expression corresponding to the sorted values of column.

The column argument can be any of the following:
- A reference to any column.
- A table with a single column.
This function is different from LASTNONBLANK in that the column is added to the filter context for the evaluation of expression.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

The following DAX query,

DAX

EVALUATE
SUMMARIZECOLUMNS(
  DimProduct[Class],
  "LNBV",
  LASTNONBLANKVALUE(
    DimDate[Date],
    SUM(FactInternetSales[SalesAmount])
   )
)

Returns,