0 out of 2 rated this helpful - Rate this topic

FIRSTNONBLANK Function

SQL Server 2012

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


FIRSTNONBLANK(<column>,<expression>)

Parameters

Term	Definition
column	A column expression.
expression	An expression evaluated for blanks for each value of column.

Property Value/Return Value

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

Remarks

The column argument can be any of the following:

A reference to any column.
A table with a single column.
A Boolean expression that defines a single-column table .

Note
Constraints on Boolean expressions are described in the topic, CALCULATE Function.

This function is typically used to return the first value of a column for which the expression is not blank. For example, you could get the last value for which there were sales of a product.

Note
To understand more about how context affects the results of formulas, see Context in DAX Formulas.

This DAX function is not supported for use in DirectQuery mode. For more information about limitations in DirectQuery models, see http://go.microsoft.com/fwlink/?LinkId=219172.

Reference

LASTNONBLANK Function

Concepts

Context in DAX Formulas

Other Resources

Statistical Functions (DAX)

DAX Function Reference

Working with Relationships in Formulas

Get Sample Data

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD