ISNONTEXT DAX Function (Information)

Syntax  |  Return values  |  Remarks  |  Related  

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

Syntax

ISNONTEXT ( <Value> )

Parameter	Attributes	Description
Value		The value you want to test.

Return values

Scalar A single boolean value.

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

Remarks

When applied to a column reference as expression, this functions tests the data type of the column, returning FALSE if the column is a string, and TRUE for any other data type.
An empty string is considered text.

Related functions

Other related functions are:

• ISLOGICAL
• ISNUMBER
• ISTEXT

Last update: Jan 11, 2021   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Jes Hansen

MSDN documentation: https://docs.microsoft.com/en-us/dax/isnontext-function-dax