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
ashc_cool10
Helper III
Helper III

Create differentiator for common column in new table

Hi Team,

 

I am trying to create one table in which data is coming from two different tables : "Table 1" & "Table 2"  which contains one common column called"MATNR" . I need to create a differentiater in a new table(Table 3) in which i need to know if i have "MATNR" number then from which table its appearing in Table 3 :
Please see below for more clarification in the excel.

Request you to please help me in acheving this .

 

Capture_2.JPG

 Regards,

Ashish

 

1 ACCEPTED SOLUTION

Hi @v-yiruan-msft ,

 

Thank you for your response . This has been sorted now .

 

Regards,

Ashish

View solution in original post

2 REPLIES 2
v-yiruan-msft
Community Support
Community Support

Hi @ashc_cool10 ,

Thanks for reaching out to us with your requirement. It seems that you want to get a table base on the table "Table1" and "Table2". But what's the backend logic? For example: Matnr 123, why the return key is 334 not 344? Could you please explain it with more details(specific example, screenshot etc.)? It would be helpful to find the solution. Thank you.

vyiruanmsft_0-1702031796033.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yiruan-msft ,

 

Thank you for your response . This has been sorted now .

 

Regards,

Ashish

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.

Top Solution Authors