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
The CONCATENATEX function concatenates texts in measures / in visuals. But how to use it to show unique values?
Let´s have the table with cars, containing Brand and Model.
We need to know, which model of which brand is there.
If we simply used CONCATENATEX to create a measure and if we used this measure in a matrix, we would see this:
Models (like Spider) are not unique. So let´s modify the formula this way:
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.
any ideas on combining values in 2 columns trough a measure.
Maybe something like sumx, countx, concatenatex? What exactly do you need?
Does the function VALUES work better than DISTINCT here?
hi thanks dude for your help.
It works perfectly into my cross table DAX
Awesome . It helped me. keep doing great work