Forum Discussion
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...
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'))
Greg_Deckler
Community Champion
Community ChampionYou 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'))
Hi Smoupre,
It works perfectly, thanks!