Table of contents
TOC
Collapse the table of content
Expand the table of content

ISNONTEXT Function (DAX)

Owen Duncan|Last Updated: 4/19/2018

Checks if a value is not text (blank cells are not text), and returns TRUE or FALSE.

Syntax

ISNONTEXT(<value>)  

Parameters

TermDefinition
valueThe value you want to check.

Return Value

TRUE if the value is not text or blank; FALSE if the value is text.

Remarks

An empty string is considered text.

Example

The following examples show the behavior of 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")  

See Also

Information Functions (DAX)

© 2018 Microsoft