Forum Discussion

Mounir's avatar
Mounir
New Member
9 years ago
Solved

Sum from two different tables based on a common unique key

Hello everyone,

 

I am a new Power BI user and still not very at ease with DAX.

 

I am trying to create a new tab which will sum the Data fields from two different tables based on a common unique key which is Month of Year as shown below:

 

 

Can anyone please explain me how to do that?

 

I couldn't find any other post covering the same question, apologies if I'm duplicating this.

 

Thanks for your help,

Mounir

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    You should be able to do something like this if the two tables are related:

     

    Data Sum = CALCULATE(SUM('Tab 1'[Data 1]),RELATEDTABLE('Tab 1')) + CALCULATE(SUM('Tab 2'[Data 2]),RELATEDTABLE('Tab 2'))

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    9 years ago

    You should be able to do something like this if the two tables are related:

     

    Data Sum = CALCULATE(SUM('Tab 1'[Data 1]),RELATEDTABLE('Tab 1')) + CALCULATE(SUM('Tab 2'[Data 2]),RELATEDTABLE('Tab 2'))
    • Mounir's avatar
      Mounir
      New Member
      9 years ago

      Hi Smoupre,

       

      It works perfectly, thanks!