Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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.   ...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

Hi@ Moscuba

You can try to this measure as below:

Measure 3 = CONCATENATE (
SELECTEDVALUE ( 'Table2'[PCATID]  )&"_",
SELECTEDVALUE ( 'Table2'[PCAT Name] )
)

Result:

Best Regards,

Lin

Anonymous's avatar
Anonymous
Not applicable
6 years ago

This is the perfect answer which I was looking for, Thanks lot for the help. Even on the microsoft own portal they mentioned the Dax function but the syntax is incorrect when we tried using text filed name which is not measures

 

https://docs.microsoft.com/en-us/dax/concatenate-function-dax

=CONCATENATE(Customer[LastName], CONCATENATE(", ", Customer[FirstName]))