DAX Function Guide

ISTEXT
Empty image or helper icon

Sam McKay

CEO & Founder

How does the ISTEXT work?
ISTEXT function (DAX) checks for text and returns either TRUE or FALSE.
ISTEXT Formula Syntax
ISTEXT (<value>)
How do you use the ISTEXT?

This function checks whether a value is text, and returns either TRUE or FALSE.

Related Blog Posts

Loading

Considerations when using the ISTEXT?

Empty strings are considered as text.

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

Related Video Tutorials

Loading

Formula examples using the ISTEXT
//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 Courses

Loading