Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 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

shaikarshad29's avatar
shaikarshad29
Frequent Visitor
4 years ago
 

Is it possible to include the final concatenated srting in table, without making use of original string columns inside table from where the final stringw as derived?