CONCATENATEX Function in Power BI

This article showcases the use of CONCATENATEX, a handy DAX function to return a list of values in a measure.

What is CONCATENATEX Function in Power BI?

Evaluates expression for each row on the table, then return the concatenation of those values in a single string result, separated by the specified delimiter.

Related Article:
How to Fix Power BI SASL Authentication Error with Impala
CONCATENATEX Function in Power BI
How to concatenate multiple column in Power BI

Syntax

CONCATENATEX (
   <table>, <expression>, [<delimiter>], [<OrderBy_Expression1>], [<Order>] …
)

Parameters

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.

Return value

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.