CONCATENATEX (DAX – Power Pivot, Power BI)
This article is about the CONCATENATEX function, which merges text strings in DAX. You can use it in measures (in contrary to CONCATENATE, also available in DAX, which can be only used for merging of columns together). If you wanted to merge text strings "conditionally" in classical Excel formula, you can use a matrix function.
How does it work?
Let´ s play with this table and merge all comments belonging to products together.
Let´s create this measure:
- All comments = CONCATENATE(Table1;Table1[Customer comment];"; ")
- table to be used,
- the column from it, that will be merged,
- the string or character that will be used as separator.
After using the measure in visual (Matrix, for example...), and splitting by product, we can see the result - merged comments.