ISERROR DAX Function (Information) Not recommended
Checks whether a value is an error, and returns TRUE or FALSE.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Value |
The value you want to test. |
Return values
A Boolean value of TRUE if the value is an error; otherwise FALSE.
Remarks
IFERROR and ISERROR are not able to catch all runtime errors. Whether or not they can catch an error depends on the choice of execution plans. When the query plan chooses a faster execution (block mode), errors may not be captured. In light of their limitations, the two functions are discouraged.
Read Appropriate use of error functions for best practices about using IFERROR and ISERROR.
Examples
-- ISERROR detects if its argument produces an error.
--
-- It is commonly replaced by IFERROR, that includes in the
-- same function both IF and ISERROR.
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
IF (
ISERROR ( INT ( VALUE ( CurrentYear ) ) ),
INT ( VALUE ( RIGHT ( CurrentYear, 4 ) ) ),
INT ( VALUE ( CurrentYear ) )
)
EVALUATE
SUMMARIZECOLUMNS (
'Date'[Calendar Year],
--"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: Nov 14, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Imke Feldmann
Microsoft documentation: https://docs.microsoft.com/en-us/dax/iserror-function-dax