Forum Discussion
Concatenate Measure not Custom Column
You can use CONCATENATE in a measure. Sample data would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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.
Hi,
Does this work?
=VALUES([PCATID])&"_"&VALUES([PCAT Name])
or
=CONCATENATEX(Data,VALUES([PCATID])&"_"&VALUES([PCAT Name]))
