ISNUMBER
Whether a value is a number; a date counts as one.
Group: Information. Compatible with DAX.
Syntax
ISNUMBER ( <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 when the value is a number of any kind, a date included; FALSE otherwise.
Remarks
- A date counts as a number here (it is one, underneath: days since 30 December 1899). To leave dates out, use
ISNUMERIC; to find dates,ISDATETIME. - Text is not a number, even when it holds digits:
ISNUMBER ( "42" )is FALSE. - A blank is not a number, and neither are TRUE and FALSE.
Examples
Values of several types
EVALUATE
ROW (
"42", ISNUMBER ( 42 ),
"2.5", ISNUMBER ( 2.5 ),
"A date", ISNUMBER ( DATE ( 2026, 11, 2 ) ),
"Text 42", ISNUMBER ( "42" ),
"Blank", ISNUMBER ( BLANK () ),
"TRUE ()", ISNUMBER ( TRUE () )
)| 42 | 2.5 | A date | Text 42 | Blank | TRUE () |
|---|---|---|---|---|---|
| TRUE | TRUE | TRUE | FALSE | FALSE | FALSE |
Which bonds have a price
Two holdings have no quoted price: blank is not a number.
EVALUATE
SELECTCOLUMNS (
Holdings,
"Bond", Holdings[Bond],
"Has a price", ISNUMBER ( Holdings[Price] )
)| Bond | Has a price |
|---|---|
| Government 2028 | TRUE |
| Government 2033 | TRUE |
| Municipal 2031 | FALSE |
| Covered 2029 | FALSE |
| Corporate 2030 | TRUE |