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 )
Examples
-- IFERROR detects if the first argument produces an error.
-- In that case, it returns the second argument, without
-- erroring out.
DEFINE
MEASURE Sales[Year Value unprotected] =
VAR CurrentYear = SELECTEDVALUE ( 'Date'[Calendar Year] )
RETURN VALUE ( CurrentYear )
MEASURE Sales[Year Value] =
VAR CurrentYear = SELECTEDVALUE ( 'Date'[Calendar Year] )
RETURN
IFERROR (
INT ( VALUE ( CurrentYear ) ),
INT ( VALUE ( RIGHT ( CurrentYear, 4 ) ) )
)
EVALUATE
SUMMARIZECOLUMNS (
'Date'[Calendar Year],
// If you uncomment the following line, the query generates an error
// "Year Value unprotected", [Year Value unprotected],
"Year Value", [Year Value]
)
ORDER BY [Calendar Year]
| Calendar Year | Year Value |
|---|---|
| 2005-01-01 | 2,005 |
| 2006-01-01 | 2,006 |
| 2007-01-01 | 2,007 |
| 2008-01-01 | 2,008 |
| 2009-01-01 | 2,009 |
| 2010-01-01 | 2,010 |
| 2011-01-01 | 2,011 |
Related functions
Other related functions are:
Last update: Oct 22, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
Microsoft documentation: https://docs.microsoft.com/en-us/dax/iferror-function-dax
2018-2021 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies