CONCATENATEX – DAX Guide

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