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. ...
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.