ISNUMBER DAX Function (Information)
Checks whether a value is a number, and returns TRUE or FALSE.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Value |
The value you want to test. |
Return values
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.
The value in the expression is irrelevant: infinity, negative infinity, and NaN all count as numbers.
IMPORTANT: This function does not test whether a string can be converted to a number.
Examples
-- ISLOGICAL, ISTEXT, ISNONTEXT and ISNUMBER check their argument
-- for the required data type.
--
-- Different results with strings, numbers, Booleans, and BLANK
EVALUATE
VAR _Logical = TRUE
VAR Number = -1.2
VAR Txt = "SQLBI"
VAR ValueTable =
{
( "ISLOGICAL(Value)", ISLOGICAL ( _Logical ), ISLOGICAL ( Number ), ISLOGICAL ( Txt ), ISLOGICAL ( BLANK () ) ),
( "ISNUMBER (Value)", ISNUMBER ( _Logical ), ISNUMBER ( Number ), ISNUMBER ( Txt ), ISNUMBER ( BLANK () ) ),
( "ISTEXT(Value)", ISTEXT ( _Logical ), ISTEXT ( Number ), ISTEXT ( Txt ), ISTEXT ( BLANK () ) ),
( "ISNONTEXT(Value)", ISNONTEXT ( _Logical ), ISNONTEXT ( Number ), ISNONTEXT ( Txt ), ISNONTEXT ( BLANK () ) )
}
RETURN
SELECTCOLUMNS(
ValueTable,
"Function Call VALUE = ",[Value1],
"TRUE", [Value2],
"-1.2", [Value3],
"""SQLBI""", [Value4],
"BLANK()", [Value5]
)
| Function Call VALUE = | TRUE | -1.2 | “SQLBI” | BLANK() |
|---|---|---|---|---|
| ISLOGICAL(Value) | true | false | false | false |
| ISNUMBER (Value) | false | true | false | false |
| ISTEXT(Value) | false | false | true | false |
| ISNONTEXT(Value) | true | true | false | true |
-- ISLOGICAL, ISTEXT, ISNONTEXT and ISNUMBER check their argument
-- for the required data type.
--
-- Different results with strings, numbers, booleans, BLANK
EVALUATE
VAR ValueToCheck = "SQLBI"
RETURN
{
( "ISLOGICAL (" & ValueToCheck & ")" , ISLOGICAL ( ValueToCheck )),
( "ISTEXT (" & ValueToCheck & ")" , ISTEXT ( ValueToCheck )),
( "ISNONTEXT (" & ValueToCheck & ")" , ISNONTEXT ( ValueToCheck )),
( "ISNUMBER (" & ValueToCheck & ")" , ISNUMBER ( ValueToCheck ))
}
| Value1 | Value2 |
|---|---|
| ISLOGICAL (SQLBI) | false |
| ISTEXT (SQLBI) | true |
| ISNONTEXT (SQLBI) | false |
| ISNUMBER (SQLBI) | false |
Related functions
Other related functions are:
Last update: Jan 31, 2023 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber,
Microsoft documentation: https://docs.microsoft.com/en-us/dax/isnumber-function-dax