IFERROR DAX Function (Logical)
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:
Last update: Sep 15, 2020 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
MSDN documentation: https://docs.microsoft.com/en-us/dax/iferror-function-dax