The Boolean data type is used to express logical conditions. For example, a calculated column defined by the following expression is of Boolean type:
= Sales[Unit Price] > Sales[Unit Cost]
You will also see Boolean data types as numbers where TRUE equals 1 and FALSE equals 0. This sometimes proves useful for sorting purposes because TRUE > FALSE.
Contributors: Alberto Ferrari, Marco Russo, Guillermo Fernandez Vizcaino