# CONCATENATEX

Concatenates the result of an expression evaluated for each row in a table.

## Syntax

CONCATENATEX(<table>, <expression>, [delimiter])


### Parameters

Term Definition
table The table containing the rows for which the expression will be evaluated.
expression The expression to be evaluated for each row of the table.
delimiter (optional) A separator to use during concatenation.

A text string.

## Remarks

• This function takes as its first argument a table or an expression that returns a table. The second argument is a column that contains the values you want to concatenate, or an expression that returns a value.

• This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

## Example

Employees table

FirstName LastName
Alan Brewer
Michael Blythe

The following formula:

CONCATENATEX(Employees, [FirstName] & " " & [LastName], ",")


Returns:
"Alan Brewer, Michael Blythe"