Value.FromText

Updated on

Value.FromText is a Power Query M function that decodes a text value and interprets it as a value with an appropriate type, such as a number, logical value, null value, datetime value, duration value, or text value. The function returns the decoded value, and an optional culture parameter may also be provided.

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

Syntax

Value.FromText(
   text as any,
   optional culture as nullable text,
) as any
Argument Attribute Description
text
culture optional The culture argument enables the specification of a Culture code (e.g., “nl-NL” or “en-US”) to align transformations with local formatting conventions. If this argument is omitted, functions default to Culture.Current, which reflects the system’s regional settings.

Description

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”).

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/value-fromtext