Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Troyvan
Helper I
Helper I

Combine 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! 

Troyvan_0-1658900691062.png

 

 

Cheers,
Troy

1 ACCEPTED SOLUTION
lbendlin
Super User
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.

 

 

View solution in original post

2 REPLIES 2
Troyvan
Helper I
Helper I

Hi @lbendlin  

 

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

Cheers,
Troy

lbendlin
Super User
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.

 

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.