Logical Functions Overview

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
BI Gorilla Blog

Last update: August 13, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/logical-functions
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.