# FIRSTNONBLANKVALUE

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

## Syntax

FIRSTNONBLANKVALUE(<column>, <expression>)


### Parameters

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

## Return value

The first non-blank value of <expression> corresponding to the sorted values of <column>.

## Remarks

• 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.

## Example

The following DAX query,

EVALUATE
SUMMARIZECOLUMNS(
DimProduct[Class],
"FNBV",
FIRSTNONBLANKVALUE(
DimDate[Date],
SUM(FactInternetSales[SalesAmount])
)
)


Returns,

DimProduct[Class] [FNBV]
L 699.0982
H 13778.24
M 1000.4375
533.83