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")  

Related DAX Functions

Related Course Modules