Logical.ToText
Turns true or false into text, for a label or a file.
Group: Values, types and errors. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Logical.ToText(logicalValue as nullable logical) as nullable text| Parameter | Type | Description |
|---|---|---|
logicalValue | nullable logical | The logical to write; null gives null. |
Returns
nullable text. "true" or "false".
Remarks
- Only logicals are accepted: a number is an error.
Text.Fromwrites any value.
Examples
A logical
Logical.ToText(true)"true"In a sentence
"Over budget: " & Logical.ToText(1200 > 1000)"Over budget: true"