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

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.