FIRSTNONBLANK Function (DAX)
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 (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.
Note
To understand more about how context affects the results of formulas, see Context in DAX Formulas.
See Also
Other Resources
Referential Integrity, PowerPivot Relationships, and the Unknown Member