Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Concatenate Data from 2 Dim Tables

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

 

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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's avatar
    v-xulin-mstf
    5 years ago

    Hi Anonymous,

     

     Try measure as:

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

    Please refer this to get more features.

     

    Best Regards,

    Link

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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's avatar
    v-xulin-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous,

     

     Try measure as:

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

    Please refer this to get more features.

     

    Best Regards,

    Link