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
Syntax
Logical.ToText( logicalValue as nullable logical ) as nullable textDescription
Creates a text value from the logical value logicalValue, either true or false. If logicalValue is not a logical value, an exception is thrown.
Examples
Create a text value from the logical true.
// Output: "true"
Logical.ToText( true )Related functions
Other functions related to Logical.ToText are:
