Sum from two different tables based on a common unique key

[Mounir]

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

[Greg_Deckler · Accepted solution]

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]

Hi Smoupre,

It works perfectly, thanks!