DAX Function Guide

ISNONTEXT
Empty image or helper icon

Sam McKay

CEO & Founder

How does the ISNONTEXT work?
ISNONTEXT function (DAX) returns TRUE for any non-text attribute, e.g. number, date or time.
ISNONTEXT Formula Syntax
ISNONTEXT (<value>)
How do you use the ISNONTEXT?

The ISNONTEXT function also returns TRUE for blank cells and for formula-returning formula cells.

Related Blog Posts

Loading

Considerations when using the ISNONTEXT?

To test if a value is not a text, use the ISNONTEXT function. The ISNONTEXT feature also returns TRUE for blank cells, and for cells that display non-text results with formulas.

ISNONTEXT is part of a group of functions called IS functions, which return the TRUE or FALSE logical values.

Related Video Tutorials

Loading

Formula examples using the ISNONTEXT
//RETURNS: Is Non-Text
=IF(ISNONTEXT(1), "Is Non-Text", "Is Text")

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

//RETURNS: Is Text
=IF(ISNONTEXT(""), "Is Non-Text", "Is Text")
Related Courses

Loading