Compare Two Columns from different tables in many to many relationship

[Anonymous]

How to compare two columns in a table visual coming from different tables, when their relationship is many to many?

In above image,

- The column "Supplier Name" is from a fact table.

- The columns "Vendor A" & "Vendor B" are from two different tables.

- The relationship between "Fact table" and "Vendor A" table is many to many.

How to compare "Supplier Name" & "Vendor A" and say they are matching or not?

Note: Since it is many to many relation, the related function is not working.

[Anonymous]

@Anonymous 

RELATEDTABLE function might work.

As @harshnathani suggests you should consider converting your model to start schema or use a bridge table for *:* relatioships.

[harshnathani]

Hi @Anonymous ,

Generally Supplier Name should come from a  Dimension Table adn should be related to your Vendor A and Vendor B Table.

I think you can try convert your model to a Star Schema.

Regards,

HN

[lbendlin]

what you are asking for is logically impossible.  Many to Many means there can be multiple rows in your fact table with supplier name MARUBENI and multiple rows in your Vendor A table with Vendor MARUBENI.  

You will want to reformulate your question, something like "How many times does the supplier name appear in the vendor table ?" so that you can actually get an answer.