Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |