ISTEXT Function (DAX)
How does the ISTEXT function (DAX) work?
ISTEXT function (DAX) checks for text and returns either TRUE or FALSE.
ISTEXT Formula Syntax
ISTEXT (<value>)
How do you use the ISTEXT function?
This function checks whether a value is text, and returns either TRUE or FALSE.
Related Blog Posts
Considerations when using the ISTEXT function
Empty strings are considered as text.
Blank cells, BLANK () are considered as non-text.
Related Video Tutorials
Formula examples using 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")