Table of contents
TOC
Collapse the table of content
Expand the table of content

ISLOGICAL Function (DAX)

Owen Duncan|Last Updated: 5/22/2018

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

Syntax

ISLOGICAL(<value>)  

Parameters

TermDefinition
valueThe value that you want to test.

Property Value/Return Value

TRUE if the value is a logical value; FALSE if any value other than TRUE OR FALSE.

Example

The following three samples show the behavior of ISLOGICAL.

//RETURNS: Is Boolean type or Logical  
=IF(ISLOGICAL(true), "Is Boolean type or Logical", "Is different type")  

//RETURNS: Is Boolean type or Logical  
=IF(ISLOGICAL(false), "Is Boolean type or Logical", "Is different type")  

//RETURNS: Is different type  
=IF(ISLOGICAL(25), "Is Boolean type or Logical", "Is different type")  

See Also

Information Functions (DAX)

© 2018 Microsoft