Related tables, but not seeing data in each other

[IanMac]

I have 2 tables:

Supplier data of sales to my company and

My company's Purchase Orders table.

They are related by a unique PO No table as Purchase Orders have multiple item lines.

The Supplier and my company use their own Item Descriptions.

When attempting to determine purchasing data from the Suppliers table to the Purchase Order data, I return multiple rows (one row per Purchase Order line), as they don't see the other table's Item Description.

There is a part number in the Supplier's data, but not the PO data.

I tried to create a CONCAT field in each table (PO No, Quantity, Unit Price) and and copied to a different query, deleted duplicates to create a relationship, but this achieved nothing.

Does anyone know how I can overcome this, other than having a lookup table with both Descriptions (there are many 100's of items).

Thank you in advance

Ian

[MFelix]

Hi @IanMac ,

To what I can understand you have a many to many relationship correct? How is the model setup?

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

[IanMac]

Hi MFelix.

Thank you for reaching out.

I have resolved my issue by creating a table with CONCATs of PO No, Qty, Line value and Item Description, which forms the one-to-many relationship that was required.

Thank you

Ian