Našimi kurzy prošlo více než 10 000+ účastníků
2 392 ověřených referencí účastníků našich kurzů. Přesvědčte se sami
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:
Arguments are:
After using the measure in visual (Matrix, for example…), and splitting by product, we can see the result – merged comments.
To see unique values as a result of CONCATENATEX see this article.
Comments are closed.
2 392 ověřených referencí účastníků našich kurzů. Přesvědčte se sami
Pište kdykoliv. Odpovíme do 24h
© exceltown.com / 2006 - 2023 Vyrobilo studio bARTvisions s.r.o.
hi
nice function
but i have issue. is it possible to merge only distinc values or sort this list?
thx
regards
jacek
You can sort normally in CONCATENATEX – using the fourth and fifth optional parameter.
To get the unique values you need something like this:
List of unique values = CALCULATE(CONCATENATEX(DISTINCT(‘table'[Column]);’table'[Column]))