Many to Many Relationship

[Eugene-CHN]

Hello, please help in such situation:

I have 3 tables without unique prospect account(simple example). I need a relationship with Event-Contracts and Event-Sales. The main idea to choose event and to show data analysis about contracts and sales. One prospect may be in different event-bases.

How to make this connection? maybe CalculateTable, but how to easy filter every Event?

[v-yuta-msft]

Hi Eugene-CHN,

Two one-many relationships  and a median table compose a many-mant relationship. You'd better create a new table which contain [Prospect] column between the three tables and make relationship between the three table and the new median table.

Keep in mind, the values in the column of new median table should be unique.

Hope it's helpful to you.

Jimmy Tao