ISLOGICAL DAX Function (Information)

Syntax  |  Return values  |  Remarks  |  Related  

Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE.

Syntax

ISLOGICAL ( <Value> )

Parameter	Attributes	Description
Value		The value you want to test.

Return values

Scalar A single boolean value.

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.

Related functions

Other related functions are:

• ISNONTEXT
• ISNUMBER
• ISTEXT

Last update: Nov 20, 2020   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber

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