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

Related Support Forum Posts

Replace the empty string to a blank value
Dynamic RANKX with Other Category
Developing Complex Dax functions

Considerations when using the ISTEXT function

Empty strings are considered as text.

Blank cells, BLANK () are considered as non-text.

Related Video Tutorials

Dynamically-Compare-Monthly-Information-Cumulatively-in-Power-BI-w-DAX-1

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

ISEMPTY
ISNONTEXT
ROUNDUP

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership