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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.