LASTNONBLANKVALUE

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

Syntax

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,

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

Returns,