FIRSTNONBLANKVALUE - Daxplained

FIRSTNONBLANKVALUE is a DAX function that returns the first non-blank value of an expression evaluated for a column.

Syntax

FIRSTNONBLANKVALUE(
   ColumnName,
   Expression
)

Argument	Properties	Description
ColumnName		The source values.
Expression		The expression to be evaluated for each value.

The first 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 FIRSTNONBLANK 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],
  "FNBV",
  FIRSTNONBLANKVALUE(
    DimDate[Date],
    SUM(FactInternetSales[SalesAmount])
   )
)

Returns,

Other functions related to FIRSTNONBLANKVALUE are: