Forum Discussion
Solved
Fields
I have two table: which reveal GrossTurnever=Q-ty*ProductPrice for every year and Margin=GrossTurnever2-GrossTurnever1
First picture below shows bi-directional relationship between tables.
Second picture shows measure for year 2016.
Hope help you.
Best regards,
You 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,
I created bridge table Table 3 with one column id_product.
But I don't know how realize formula Q-ty*Price across thase table.
First picture below shows bi-directional relationship between tables.
Second picture shows measure for year 2016.
Hope help you.
Best regards,
Thanks a lot!