IFERROR DAX Function (Logical)

Syntax  |  Return values  |  Remarks  |  Related  

Returns value_if_error if the first expression is an error and the value of the expression itself otherwise.

Syntax

IFERROR ( <Value>, <ValueIfError> )

Parameter	Attributes	Description
Value		Any value or expression.
ValueIfError		Any value or expression.

Return values

Scalar A single value of any type.

A scalar of the same type as Value

Remarks

The IFERROR function is a faster implementation of a semantically equivalent IF / ISERROR pattern.

IFERROR ( A, B )

-- Corresponds to

IF ( ISERROR ( A ), B, A )

Related functions

Other related functions are:

• IF
• ISERROR
• DIVIDE

Last update: Nov 20, 2020   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber

MSDN documentation: https://docs.microsoft.com/en-us/dax/iferror-function-dax