Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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!