Home Library Learn Samples Downloads Support Community Forums
0 out of 3 rated this helpful - Rate this topic

FIRSTNONBLANK Function (DAX)

SQL Server 2008 R2

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

Copy 

FIRSTNONBLANK(<column>,<expression>)

Term

Definition

column

A column expression.

expression

An expression evaluated for blanks for each value of column.

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

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 .

NoteNote

Constraints on Boolean expressions are described in the topic, CALCULATE Function (DAX).

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.

NoteNote

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

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.