COALESCE Returns the first expression that does not evaluate to BLANK. If all expressions evaluate to BLANK, BLANK is returned.


COALESCE(expression, expression[, expression]…)


Expression – Any DAX expression that returns a scalar expression.

Return Value

A scalar value coming from one of the expressions or BLANK if all expressions evaluate to BLANK.

Reference Data

DAX Functions / Logical Functions / COALESCE