Logical Functions Overview

Updated on

Delve into Logical Functions in Power Query M Language, essential for performing logical operations for your data transformations. This page provides a comprehensive list and descriptions of Logical Functions available in the M Language.

Logical Functions in Power Query M

FunctionDescriptionInputOutput
Logical.FromCreates a logical from the given value.AnyLogical
Logical.FromTextCreates a logical value from the text values “true” and “false”.TextLogical
Logical.ToTextReturns the text “true” or “false” given a logical value.LogicalText

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/logical-functions