Join 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!View all the Fabric Data Days sessions on demand. View schedule
Hi,
I want to build a Matrix for this Sample Data
| Model | Type |
| Model 1 | A45 |
| Model 1 | A12 |
| Model 2 | A45 |
| Model 2 | B23 |
| Model 2 | A12 |
| Model 3 | A45 |
| Model 3 | B23 |
| Model 3 | E24 |
From this Data i want to find out the absolute differences and get a Matrix like this.
| Model 1 | Model 2 | Model 3 | |
| Model 1 | 0 | 1 | 2 |
| Model 2 | 1 | 0 | 2 |
| Model 3 | 2 | 2 | 0 |
Can someone help me and give me an advice how to come to the solution.
Thanks a lot.
Can you please elaboarte, I'm not able to understand what exactly the calculations are taking place.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!