ISTEXT DAX Function (Information)
Checks whether a value is text, and returns TRUE or FALSE.
Syntax
ISTEXT ( <Value> )
| Parameter | Attributes | Description |
|---|---|---|
| Value |
The value you want to test. |
Return values
Scalar A single boolean value.
TRUE if the value is text; otherwise FALSE.
Remarks
When applied to a column reference as expression, this functions tests the data type of the column, returning TRUE whether the column is a string data type and FALSE for any other data type.
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 |
-- When you pass a column as the argument, these functions
-- check the metadata of the column, not the specific
-- content of the column in the current row
EVALUATE
VAR A = DATATABLE (
"S", STRING,
"I", INTEGER,
{
{ "A", 1 }, -- "A" is a string
{ "B", 2 }, -- "B" is a string
{ "1", 1 } -- "1" is considered a string, even though it contains a number
}
)
VAR ValueToCheck = "SQLBI"
RETURN
{
( "ISTEXT(S)", COUNTROWS ( FILTER ( A, ISTEXT ( [S] ) ) ) ),
( "ISNUMBER(S)", COUNTROWS ( FILTER ( A, ISNUMBER ( [S] ) ) ) ),
( "ISTEXT(I)", COUNTROWS ( FILTER ( A, ISTEXT ( [I] ) ) ) ),
( "ISNUMBER(I)", COUNTROWS ( FILTER ( A, ISNUMBER ( [I] ) ) ) )
}
| Value1 | Value2 |
|---|---|
| ISTEXT(S) | 3 |
| ISNUMBER(S) | (Blank) |
| ISTEXT(I) | (Blank) |
| ISNUMBER(I) | 3 |
Related functions
Other related functions are:
Last update: Apr 2, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/istext-function-dax
2018-2021 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies