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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Mvvv
New Member

2 Tables with different Keys to sum in the rows - how to get an common summary about both tables?

Hi,
it's difficult to explain and I think to understand, so I made screenshots.

 

The first table has Codes in it, the second too. There a different code variantes that have to summarize, but let's look only the my example now. Here I explan with aa, ab and ac Codes. The ab and ac Codes are only in Table 1. 

 

I3KpANe

 

For my final summarize I need all values from Table 1, which have the same Nr and the code must be aa, ab or ac. In Table 2 there exists only Code aa.
So if I make a summarize now. I have data in Column aa for both tables, but only for ab and ac in Table1 Colums.
At the end, I need only a summarize Column for Code aa, ab and ac togehter, with the sum of all from Table 1 and the sum of all from aa Code table 2.

 

oZD7sfM
What could be the best idea to solve this?

I tried a lot, with helping tables and complicates Power Query M Codes, but I never get the wanted result. I think maybe I can't see clear anymore about that one whole day problem now. I hope someone has a maybe "easy" solution?

Best thanks in advance.

1 REPLY 1
Mvvv
New Member

O.K. I found a solution after a night of sleep. I used search and replace and replaced as example, all ab and ac with aa.
I'm still interessted in better suggestions.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors