Logical.FromText Function in Power Query
The Logical.FromText function returns a logical value of “true” or “false” from a text value.
Syntax
Logical.FromText(text as nullable text) as nullable logical
This function only accepts "true" or "false" (case insensitive) as valid inputs.
Example: Create a logical value from the text string "true".
Power Query M
let Source = Logical.FromText("true") in Source
The output of the above code is TRUE.
Example:
Power Query M
let Source = Value.Type(Logical.FromText("true")) in Source
The output of the above code is logical.