Value.FromText
This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.
Decodes a value from a textual representation, value, 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.
Value.FromText(value as text, optional culture as nullable text)
| Argument | Description |
|---|---|
| value | The value to transform. |
| optional culture | A text value corresponding to the culture values supported on your version of Windows, such as "en-US". If the culture is not specified, the current user culture is used. For a list of culture names, see National Language Support (NLS) API Reference. |
Value.FromText("1") equals 1
Value.FromText("2012/5/16") equals #date(2012,5,16)
Value.FromText("null") equals null
Value.FromText("somevalue") equals "somevalue"
Show: