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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi,
Can I create table or matrix using column and row number example ?
Row | colum | value |
1 | 1 | 10 |
2 | 1 | 20 |
3 | 1 | 30 |
1 | 2 | 40 |
and result sholud be
10 | 40 |
20 | |
30 |
Thanks for help
Solved! Go to Solution.
@ayaasfour , take [row] on row and [column] on the column or the matrix and take the max of [value] in the values
@ayaasfour , take [row] on row and [column] on the column or the matrix and take the max of [value] in the values