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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Eugene-CHN
Frequent Visitor

Many to Many Relationship

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?

Capture.PNG

1 REPLY 1
v-yuta-msft
Community Support
Community Support

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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