Logical.ToText is a Power Query M function that creates a text value from a logical value, either “true” or “false”. The function returns the created text value or throws an exception if the input is not a logical value.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


Logical.ToText( logicalValue as nullable logical ) as nullable text


Creates a text value from the logical value logicalValue, either true or false. If logicalValue is not a logical value, an exception is thrown.


Create a text value from the logical true.

// Output: "true"
Logical.ToText( true )

Other functions related to Logical.ToText are:

BI Gorilla Blog

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