Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Hello everyone
Could you please help me with one power query question I struggle with: what is the optimal way to fully merge two tables for a case like this?
For instance, when I use full outer merge, Product B will appear only once at the bottom of the merged table, not several times for each store as I would need it
Thanks for your reply
Though when I use merge by the key of Product the result I get is something like:
and what I cant figure out is what is the way to achieve this kind of merge (= query to make merges for each store separately, not just aggregated)
you can merge these two table the key of Product.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.