Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
106 | |
79 | |
71 | |
67 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |