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 corresponds to an IF / ISERROR pattern.
IFERROR ( A, B ) -- Corresponds to IF ( ISERROR ( A ), B, A )
Related functions
Other related functions are:
Last update: Feb 6, 2019 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/iferror-function-dax