ISNONTEXT
Whether a value is not text; a blank is not text.
Group: Information. Compatible with DAX.
Syntax
ISNONTEXT ( <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 not text: a number, a date, TRUE or FALSE, or a blank.
Remarks
- A blank counts as non-text: TRUE. Empty text is text: FALSE.
- It is
NOT ISTEXT ( value ), and so it tells nothing about whether a value is there; test that withISBLANK.
Examples
Values of several types
EVALUATE
ROW (
"Pils", ISNONTEXT ( "Pils" ),
"Empty text", ISNONTEXT ( "" ),
"42", ISNONTEXT ( 42 ),
"Blank", ISNONTEXT ( BLANK () ),
"A date", ISNONTEXT ( DATE ( 2026, 11, 2 ) )
)| Pils | Empty text | 42 | Blank | A date |
|---|---|---|---|---|
| FALSE | FALSE | TRUE | TRUE | TRUE |
A column of numbers
Every price is a number or a blank, so none is text.
EVALUATE
SELECTCOLUMNS (
Holdings,
"Bond", Holdings[Bond],
"Price", Holdings[Price],
"Not text", ISNONTEXT ( Holdings[Price] )
)| Bond | Price | Not text |
|---|---|---|
| Government 2028 | 97.84 | TRUE |
| Government 2033 | 92.15 | TRUE |
| Municipal 2031 | (blank) | TRUE |
| Covered 2029 | (blank) | TRUE |
| Corporate 2030 | 101.3 | TRUE |