Text.From
Any simple value written as text: numbers, dates, times, durations, true and false.
Group: Text and characters. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Text.From(value as any, optional culture as nullable text) as nullable text| Parameter | Type | Description |
|---|---|---|
value | any | The value to write: a number, date, time, datetime, datetimezone, duration, logical or text. |
culture | nullable text optional | A culture's name, such as "de-DE", for how numbers and dates are written. Left out, the culture of the query. |
Returns
nullable text. The value as text; null when the value is null. A text comes back as it is.
Remarks
- Left out, the culture is the query's (
Culture.Current): the model's Locale for import, else the model's own culture, else en-US. The examples here run in en-US. In en-US dates are written month first, with a point before the decimals. - A duration is written as days, a point, then hours:minutes:seconds, in every culture: 1.02:03:04.
- Lists, records, tables and functions have no text form: they give an error.
Compared with Power Query
Known difference in OpenBI Studio 0.3.79, found while this page was written and run on its engine:
Text.From(123456789012345678): Power Query gives "123456789012345678": it keeps every digit of a number written in the query. OpenBI holds every number as a double, exact to 15 or 16 digits, and gives "123456789012345680".
Examples
A price
Text.From(1234.5)"1234.5"A date
In en-US, month first.
Text.From(#date(2026, 3, 1))"3/1/2026"The price in German
Text.From(1234.5, "de-DE")"1234,5"