CONCATENATEX Function (DAX)

 
System_CAPS_ICON_note.jpg Note


This function is included in SQL Server 2016 Analysis Services (SSAS), Power Pivot in Excel 2016, and Power BI Desktop only. Information provided here is subject to change.

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

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

Parameters

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

A text string.

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.

Employees table

FirstNameLastName
AlanBrewer
MichaelBlythe

CONCATENATEX(Employees, [FirstName] & “ “ & [LastName], “,”)

Returns "Alan Brewer, Michael Blythe"

Community Additions

ADD
Show: