ISNONTEXT DAX Function (Information)
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:
Last update: Feb 6, 2019 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Jes Hansen
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/isnontext-function-dax