Forum Discussion

Helper I

8 years ago

Solved

Fields

I have two table: which reveal GrossTurnever=Q-ty*ProductPrice for every year and Margin=GrossTurnever2-GrossTurnever1

Thyago_Rezende
8 years ago
First picture below shows bi-directional relationship between tables.

Second picture shows measure for year 2016.

Hope help you.
Best regards,

Helper I

8 years ago

@Thyago_Rezende

Table 1 aditional have two columns:

Id_transaction

Datetime

Id_product in first table don't unique.

Do you undestand me?

Resolver I

8 years ago

Hello Grizman,

Can you send sample data? Or display all fields from tables?

Grizman
Helper I
8 years ago
Thyago_Rezende
Resolver I
8 years ago
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.

https://www.sqlbi.com/articles/optimize-many-to-many-calculation-in-dax-with-summarize-and-cross-table-filtering/

Regards,
Grizman
Helper I
8 years ago
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.
Thyago_Rezende
Resolver I
8 years ago
First picture below shows bi-directional relationship between tables.

Second picture shows measure for year 2016.

Hope help you.
Best regards,
Grizman
Helper I
8 years ago
Thanks a lot!