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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
HitcH
Helper II
Helper II

Tables connection not working

Hi everyone

I have three different tables.

1) Document number and its value

2) Document number and customer

3) Customer and customer details

 

The three tables are linked:

HitcH_0-1693928441853.png

 

I want to create a table with customer and value of the document numbers linked to those customer, but it is not working:

HitcH_1-1693928535354.png

 

Any idea about how could I do that?

 

Thanks in advance

 

9 REPLIES 9
parry2k
Super User
Super User

@HitcH seems like we both are talking about different things now. Better to put some sample pbix file and share them using one drive/google drive. remove sensitive information before sharing.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Up 😞

parry2k
Super User
Super User

@HitcH 

1) Document number and its value - let's call it Table1

2) Document number and customer - let's call it Table2

3) Customer and customer details - let's call it Table3

 

First relatinship - Table 1 will join with Table 2 on document number, with 1 to many relationship, 1 on Table 2 side and many on Table 1 side.

 

2nd relationship - Table 2 will join with Table 3 on customer number with 1 to many relationship, 1 on Table 3 side, and many on Table 2 side.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

The problem is that the one that you call "Table 2" (in my screenshot it's the "LPT Delivery") has many documents with the same number because they are related to the different products, so the relation has to be "many to 1" instead of "1 to many".

I need to have a sort of vlookup in which I could connect "many" document numbers to the customer

parry2k
Super User
Super User

@HitcH the screenshot you shared is not what I mentioned.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Then I'm sorry but I couldn't understand your explanation, can you add some more details?

parry2k
Super User
Super User

@HitcH this is how it should work:

 

Document with Value will connect to document with customer on document number

document with customer will connect to customer on customer number

 

and now you can use customer from customer table and value from the value column



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

But that is exactly what I did, and it is not working... 😞

Helpful resources

Announcements
October NL Carousel

Fabric Community Update - October 2024

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