Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |