ISNUMBER DAX Function (Information)
Checks whether a value is a number, and returns TRUE or FALSE.
Syntax
ISNUMBER ( <Value> )
| Parameter | Attributes | Description |
|---|---|---|
| Value |
The value you want to test. |
Return values
Scalar A single boolean value.
TRUE if the value is numeric; otherwise FALSE.
Remarks
When applied to a column reference as expression, this functions tests the data type of the column, returning TRUE whether the column is of any numeric data type (Currency, DateTime, Decimal, Integer) and FALSE for any other data type.
IMPORTANT: This function does not test whether a string can be converted to a number.
Related functions
Other related functions are:
Last update: Oct 20, 2018 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/isnumber-function-dax