ISLOGICAL DAX Function (Information)
Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE.
Syntax
Parameter | Attributes | Description |
---|---|---|
Value |
The value you want to test. |
Return values
TRUE if the value is a logical value; FALSE if any value other than TRUE or FALSE.
Remarks
When applied to a column reference as expression, this functions tests the data type of the column and not whether it is possible to execute a type conversion to a Boolean.
Examples
-- ISLOGICAL, ISTEXT, ISNONTEXT and ISNUMBER check their argument -- for the required data type. -- -- Different results with strings, numbers, Booleans, and BLANK EVALUATE VAR _Logical = TRUE VAR Number = -1.2 VAR Txt = "SQLBI" VAR ValueTable = { ( "ISLOGICAL(Value)", ISLOGICAL ( _Logical ), ISLOGICAL ( Number ), ISLOGICAL ( Txt ), ISLOGICAL ( BLANK () ) ), ( "ISNUMBER (Value)", ISNUMBER ( _Logical ), ISNUMBER ( Number ), ISNUMBER ( Txt ), ISNUMBER ( BLANK () ) ), ( "ISTEXT(Value)", ISTEXT ( _Logical ), ISTEXT ( Number ), ISTEXT ( Txt ), ISTEXT ( BLANK () ) ), ( "ISNONTEXT(Value)", ISNONTEXT ( _Logical ), ISNONTEXT ( Number ), ISNONTEXT ( Txt ), ISNONTEXT ( BLANK () ) ) } RETURN SELECTCOLUMNS( ValueTable, "Function Call VALUE = ",[Value1], "TRUE", [Value2], "-1.2", [Value3], """SQLBI""", [Value4], "BLANK()", [Value5] )
Function Call VALUE = | TRUE | -1.2 | “SQLBI” | BLANK() |
---|---|---|---|---|
ISLOGICAL(Value) | true | false | false | false |
ISNUMBER (Value) | false | true | false | false |
ISTEXT(Value) | false | false | true | false |
ISNONTEXT(Value) | true | true | false | true |
-- 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: Dec 4, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
Microsoft documentation: https://docs.microsoft.com/en-us/dax/islogical-function-dax