ISNONTEXT Function (DAX)

How does the ISNONTEXT function (DAX) 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 function?

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

Related Blog Posts

Related Support Forum Posts

Accessing Matrix hierarchy levels
Dynamic RANKX with Other Category
Developing Complex Dax functions

Considerations when using the ISNONTEXT function

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

Formula examples using the ISNONTEXT function

//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 DAX Functions

ISTEXT
ISNUMBER
ISEMPTY

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