ISNONTEXT DAX Function (Information)
Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE.
Syntax
Parameter | Attributes | Description |
---|---|---|
Value |
The value you want to test. |
Return values
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.
Examples
-- ISLOGICAL, ISTEXT, ISNONTEXT and ISNUMBER check their argument -- for the required data type. -- -- Different results with strings, numbers, booleans, BLANK EVALUATE VAR ValueToCheck = "SQLBI" RETURN { ( "ISLOGICAL (" & ValueToCheck & ")" , ISLOGICAL ( ValueToCheck )), ( "ISTEXT (" & ValueToCheck & ")" , ISTEXT ( ValueToCheck )), ( "ISNONTEXT (" & ValueToCheck & ")" , ISNONTEXT ( ValueToCheck )), ( "ISNUMBER (" & ValueToCheck & ")" , ISNUMBER ( ValueToCheck )) }
Value1 | Value2 |
---|---|
ISLOGICAL (SQLBI) | false |
ISTEXT (SQLBI) | true |
ISNONTEXT (SQLBI) | false |
ISNUMBER (SQLBI) | false |
Related functions
Other related functions are:
Last update: Jun 27, 2022 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Jes Hansen
Microsoft documentation: https://docs.microsoft.com/en-us/dax/isnontext-function-dax