Hi
I downloaded this example from the internet (please see the link below). The author I think did the merge using power bi data model. I am not sure how the author managed to do that in one table. Please see the next 2 screenshot. I tried to do the data modling
I tried to do the data modling but I got different modling, please see the pic below
The excel source files and the pbi file are here:
https://drive.google.com/drive/folders/1ChLRSjbzKuk7LioiJUWcAVSypMVmiyWg?usp=sharing
If you right click on the 2012 table in the .pbix file you can go to 'Edit Query' and see all the transofrmations the user applied to the files.
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
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.
