Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

ISTEXT Function (DAX)

 

Checks if a value is text, and returns TRUE or FALSE.


ISTEXT(<value>)

Term

Definition

value

The value you want to check.

TRUE if the value is text; otherwise FALSE

The following examples show the behavior of the ISTEXT function.

//RETURNS: Is Text
=IF(ISTEXT("text"), "Is Text", "Is Non-Text")

//RETURNS: Is Text
=IF(ISTEXT(""), "Is Text", "Is Non-Text")

//RETURNS: Is Non-Text
=IF(ISTEXT(1), "Is Text", "Is Non-Text")

//RETURNS: Is Non-Text
=IF(ISTEXT(BLANK()), "Is Text", "Is Non-Text")

Community Additions

ADD
Show:
© 2015 Microsoft