Forum Discussion
Concatenate Measure not Custom Column
I need to Concatenate Two text strings for a Matrix to simplify the view. We have a Data Cube that does not allow the addition of Tables or Custom Columns. DAX CONCATENATE is for a custom Column. ...
The Data is Text columns in this case. When I trierd CONCATENATE it did not work. It refused to use valid table and fields.
Here is the example I saw in the DAX Pages:
=CONCATENATE(Customer[LastName], CONCATENATE(", ", Customer[FirstName]))
PCATID PCAT Name
AAAA Sealant 1
AAAB Sealant 2
BBBA Adheasive1
BBBB Adheasive2
I'' like to join the two with a space or underscore in between like:
AAAA _Sealant1
No Number conversions needed.
Hi,
Does this work?
=VALUES([PCATID])&"_"&VALUES([PCAT Name])
or
=CONCATENATEX(Data,VALUES([PCATID])&"_"&VALUES([PCAT Name]))