Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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.

 

SAN2021_0-1612949587276.png

 

 

Eg: report is like below

 

DQ_ITEM- Item_id || DIM_Store-STORE_Code

 

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

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

View solution in original post

v-xulin-mstf
Community Support
Community Support

Hi @Anonymous,

 

 Try measure as:

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

Please refer this to get more features.

 

Best Regards,

Link

View solution in original post

2 REPLIES 2
v-xulin-mstf
Community Support
Community Support

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
Super User
Super User

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.