ISNUMERIC
Whether a value is a number: whole, decimal or fixed decimal (a date doesn't count).
Group: Information. Compatible with DAX.
Syntax
ISNUMERIC ( <value> )| Parameter | Type | Description |
|---|---|---|
value | Value | What is tested: a constant, a column in a row context, a measure or any expression. |
Returns
Boolean. TRUE for a whole number, a decimal number or a fixed decimal number; FALSE otherwise.
Remarks
- Unlike
ISNUMBER, a date is not counted: FALSE. - Text, TRUE and FALSE, and a blank are not numeric.
- One of the newer type tests:
ISINT64,ISDOUBLEandISCURRENCYeach test for one kind of number; ISNUMERIC for any of the three.
Examples
Numbers, and what is not
EVALUATE
ROW (
"7", ISNUMERIC ( 7 ),
"2.5", ISNUMERIC ( 2.5 ),
"CURRENCY ( 2 )", ISNUMERIC ( CURRENCY ( 2 ) ),
"A date", ISNUMERIC ( DATE ( 2026, 11, 2 ) ),
"Text 7", ISNUMERIC ( "7" ),
"Blank", ISNUMERIC ( BLANK () )
)| 7 | 2.5 | CURRENCY ( 2 ) | A date | Text 7 | Blank |
|---|---|---|---|---|---|
| TRUE | TRUE | TRUE | FALSE | FALSE | FALSE |