Logical.Type

Logical.Type is a type facet in the Power Query M language. It represents the default type claim for the ‘type logical’. It is used primarily for logical operations and conditions within Power Query M, such as filtering and decision-making processes. The base type of ‘type logical’ in Power Query is for boolean values.

Examples

Generally, you will face a facet when transforming column types. You can transform a column into the specified type by using Table.TransformColumnTypes:

Table.TransformColumnTypes( Source, {{ "myColumn", Logical.Type }} )

Or when adding a column using Table.AddColumn:

Table.AddColumn( Source, "myColumn", TRUE, Logical.Type" )

To inspect the kind of value you are dealing with, you can make use of the Table.Schema function. Applying it to a table returns a table with information about your columns. The Table.SingleRow function then transforms the result into a record, for easier reading.

let 
  a =  TRUE,
   // Ascribes the default type claim facet for 'type logical'
  b = Value.ReplaceType( a, Logical.Type ),
  // Returns a table containing a value with the ascribed "Logical.Type" 
  c = #table(type table [Col1 = Value.Type( b ) ], { b } ), 
  // Shows the Table information, including typeName and value kind
  d = Table.Schema( c ),
  // For easier viewing, return table as record
  e = Table.SingleRow( d )
in 
  e

Related facets

Other related facets are:

• Any.Type
• Binary.Type
• Byte.Type
• Character.Type
• Currency.Type
• Date.Type
• DateTime.Type
• DateTimeZone.Type
• Decimal.Type
• Double.Type
• Duration.Type
• Function.Type
• Guid.Type
• Int16.Type
• Int32.Type
• Int64.Type
• Int8.Type
• List.Type
• None.Type
• Null.Type
• Number.Type
• Password.Type
• Percentage.Type
• Record.Type
• Single.Type
• Table.Type
• Text.Type
• Time.Type
• Type.Type
• Uri.Type

Contribute » | Contributors: Rick de Groot