Text.Combine
TextJoins a list of text values into a single text value with an optional separator.
Syntax
Text.Combine(texts as list, optional separator as nullable text) as textParameters
| Name | Type | Required | Description |
|---|---|---|---|
texts | list | Yes | A list of text values to combine. |
separator | text | No | A text value to insert between each item. If omitted, items are concatenated directly. |
Return Value
text — A single text value created by joining all items in the list.
Remarks
Text.Combine concatenates a list of text values into a single string. Pass a separator to insert a delimiter between each value — for example, a comma, space, or newline.
Null values in the list are skipped (not included in the output). If all values are null, the result is an empty string.
Examples
Example 1: Combine customer cities
let
Cities = Table.Column(Customers, "City"),
Combined = Text.Combine(Cities, ", ")
in
#table({"CityList"}, {{Combined}})Result
CityList | |
|---|---|
| 1 | New York, Chicago, Houston, Seattle |
Compatibility
✓ Power BI Desktop✓ Power BI Service✓ Excel Desktop✓ Excel Online✓ Dataflows✓ Fabric Notebooks