Combine matrix total from different datasets

[Troyvan]

Hi, 

I'm creating a financial forcast report with different accounts (AU & NZ). 

I've created two SharePoint list for this accounts. 

Each account has Job No and value per month. On a higher level, I want to be able to show total of both AU and NZ values per month, quarter & year in the same Matrix. Can you please help me be able to achieve this? 

Here's what I have so far, my last 2 matrix is fine. I just need to be able to combine the first two. Thank you so much! 

Cheers,
Troy

[Troyvan]

Hi @lbendlin  

Thank you for this. I think I was able to combine the data. 

Cheers,
Troy

[lbendlin · Accepted solution]

In DAX you can use the UNION() function to append tables. The preference would be to do this further upstream though, for example in Power Query.  Add a column to each table to indicate which country it is for, then append the tables  via "&"  or use the "Append"  function.