DAX Function Guide

Empty image or helper icon

Sam McKay

CEO & Founder

How does the CONCATENATEX work?
The CONCATENATEX function (DAX) evaluates the result of an expression for each row in a table. It returns the concatenation in a single string, separated by the specified delimiter.

     <table> , <expression>, [delimited]

How do you use the CONCATENATEX?

This function’s parameters include a table containing the rows, the expression to be evaluated for each row, the delimiter which serves as separator during the concatenation, the column by which the values are concatenated, and the order which can either be ascending or descending.

Related Blog Posts


Considerations when using the CONCATENATEX?

This function iterates the rows in the table as its first argument. For each row, it executes the expression provided in the second argument, which is a column that contains the values you want to concatenate, or an expression that returns a value.

Related Video Tutorials


Formula examples using the CONCATENATEX

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

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

= CONCATENATEX (Products, [Product],”,”, [Product Key], DESC)

Related Courses