Forum Discussion
Fields
First picture below shows bi-directional relationship between tables.
Second picture shows measure for year 2016.
Hope help you.
Best regards,
Hi Grizman,
Please review my previous post, I have created a pbix file based on the sample data in your original post.
What's the problem in your scenario now? I didn't see the id_transaction in your table data, please clarify sample data and your requirement.
Best Regards,
Qiuyun Yu
Table 1 aditional have two columns:
Id_transaction
Datetime
Id_product in first table don't unique.
Do you undestand me?
Who can help?
Can anybody help me?
Please help resolve my problem
Grizman wrote:
Table 1 aditional have two columns:
Id_transaction
Datetime
Id_product in first table don't unique.
Do you undestand me?
Can you share sample data of those two tables and your expected results?
Best Regards,
Qiuyun YuYou must create a Bridge Table for relation both Table1 and Table2. A bridge table with PrimaryKey from id_Product and bi-directional relationship.
This article below, explain about pattern works for many to many relationship.Regards,