ISSTRING
Whether a value is text (as ISTEXT).
Group: Information. Compatible with DAX.
Syntax
ISSTRING ( <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 text, empty text included; FALSE for numbers, dates, logical values and blanks.
Remarks
- The same test as
ISTEXT, under the name of the newer family of type tests. - Empty text counts as text; a blank does not.
- Whatever
FORMATgives is text, soISSTRING ( FORMAT ( 1, "0" ) )is TRUE.
Examples
Text and not text
EVALUATE
ROW (
"Pils", ISSTRING ( "Pils" ),
"Empty text", ISSTRING ( "" ),
"1", ISSTRING ( 1 ),
"Blank", ISSTRING ( BLANK () ),
"FORMAT ( 1 )", ISSTRING ( FORMAT ( 1, "0" ) )
)| Pils | Empty text | 1 | Blank | FORMAT ( 1 ) |
|---|---|---|---|---|
| TRUE | TRUE | FALSE | FALSE | TRUE |