Value.FromText(text as any, optional culture as nullable text) as any


Decodes a value from a textual representation, text, and interprets it as a value with an appropriate type. Value.FromText takes a text value and returns a number, a logical value, a null value, a datetime value, a duration value, or a text value. The empty text value is interpreted as a null value. An optional culture may also be provided (for example, “en-US”).

Reference Data

Power Query M Functions / Text Functions / Value.FromText