Text.From
TextConverts a value to its text representation.
Syntax
Text.From(value as any, optional culture as nullable text) as nullable textParameters
| Name | Type | Required | Description |
|---|---|---|---|
value | any | Yes | The value to convert to text. |
culture | text | No | A culture code (e.g., "en-US") that determines locale-specific formatting. |
Return Value
text — The text representation of the value.
Remarks
Text.From converts a value of any type to its text representation. Numbers, dates, logicals, and other types are formatted as text strings. Pass a culture code to control locale-specific formatting (e.g., decimal separators, date formats).
This is commonly used when concatenating non-text values with text — for example, building a label like "Order #" & Text.From([OrderID]).
Examples
Example 1: Convert order IDs to text
Table.AddColumn(
Table.SelectColumns(Table.FirstN(Sales, 3), {"OrderID", "Product"}),
"Label", each "Order #" & Text.From([OrderID]), type text
)Result
OrderID | Product | Label | |
|---|---|---|---|
| 1 | 1 | Widget A | Order #1 |
| 2 | 2 | Gadget B | Order #2 |
| 3 | 3 | Widget C | Order #3 |
Compatibility
✓ Power BI Desktop✓ Power BI Service✓ Excel Desktop✓ Excel Online✓ Dataflows✓ Fabric Notebooks