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,

Thyago_Rezende's avatar
Thyago_Rezende
Resolver I
8 years ago

Hi,

 

First, you need to transform both columns year and its values in 2 columns only. 

 

After that you can use:
GrossTurneverYear2016 = 
SUMX  ( 
             FILTER (

                          Table#2;
                          PriceYear = 2016
             );
             PriceValue2016 * RELATED ( Table#1[Q-ty])
)

Regards,