Forum Discussion
Concatenate Measure not 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.
When working with measures, you need to do an aggregation on a column, like MAX:
Measure = MAX([PCATID]) & "_" & MAX([PCAT Name])
And I would use the & operator instead of CONCATENATE.
The MAX will not work mwith Text / String. That was the only solution that accepted the fields though.
CONCATENATE Will not accept the fields and I tried ISTEXT.
This is very odd and I'm wondering if it's ther table format. Though, everywhere I look I see that concatenating needs to be done as a Column.
We'll be requesting that we can make columns in the data "cube".
Cheers and thank you.
The MAX will not work mwith Text / String. That was the only solution that accepted the fields though.
CONCATENATE Will not accept the fields and I tried ISTEXT.
This is very odd and I'm wondering if it's ther table format. Though, everywhere I look I see that concatenating needs to be done as a Column.
We'll be requesting that we can make columns in the data "cube".
Cheers and thank you.