Concatenate Data from 2 Dim Tables

[Anonymous]

Hi Experts,

I have DQ_ITEM AND STORE table in model which is joined with two facts. I want to concate two column from Item and Store. How is it possible.

Eg: report is like below

DQ_ITEM- Item_id || DIM_Store-STORE_Code

[amitchandak · Accepted solution]

@Anonymous , In a visual you need to take these two and a common measure from one of the fact table to get data.

[v-xulin-mstf · Accepted solution]

Hi @Anonymous,

 Try measure as:

CONCATENATE(<DQ_ITEM- Item_id>, <DIM_Store-STORE_Code>)  

Please refer this to get more features.

Best Regards,

Link

[amitchandak · Accepted solution]

@Anonymous , In a visual you need to take these two and a common measure from one of the fact table to get data.