Forum Discussion

Grizman's avatar
Grizman
Helper I
8 years ago
Solved

Fields

I have two table:     which reveal GrossTurnever=Q-ty*ProductPrice for every year and Margin=GrossTurnever2-GrossTurnever1  
Need Help
  • Thyago_Rezende's avatar
    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,

Grizman's avatar
Grizman
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? 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago
Grizman wrote:

@Thyago_Rezende

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 Yu