Forum Discussion
Helper ICombine matrix total from different datasets
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
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.
2 Replies
- lbendlin
Super User
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.
