Forum Discussion
Solved
PowerBI Matrix to Combine Rows with the Same Value
I want to make my Rows combine all same values. What I am getting now is its creating a hierarchy. To combine Calc 1 and Calc2
Hi, engrchris
You can try the following methods.
Table 2 = Var table1=SUMMARIZE('Table','Table'[ISO],'Table'[Date],'Table'[Calc 1]) Var table2=SUMMARIZE('Table','Table'[ISO],'Table'[Date],'Table'[Calc 2]) Var table3=SUMMARIZE('Table','Table'[ISO],'Table'[Date],'Table'[Calc 3]) Return UNION(table1,table2,table3)Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I want to create a matrix
from this:
| ISO | Date | Calc 1 | Calc 2 | Calc 3 |
| ISO-001 | 7-Jul | CS-001 | CS-002 | CS-003 |
| ISO-002 | 14-Jul | CS-003 | ||
| ISO-003 | 21-Jul | CS-002 | CS-004 | |
| ISO-004 | 28-Jul | CS-004 |
to this matrix:
| 7-Jul | 14-Jul | 21-Jul | 28-Jul | |
| CS-001 | ISO-001 | |||
| CS-002 | ISO-001 | ISO-003 | ||
| CS-003 | ISO-001 | ISO-002 | ||
| CS-004 | ISO-003 | ISO-004 |
Hi,
How is your source data table arranged. Share that in a format that can be pasted in an MS Excel file.
Hi, engrchris
You can try the following methods.
Table 2 = Var table1=SUMMARIZE('Table','Table'[ISO],'Table'[Date],'Table'[Calc 1]) Var table2=SUMMARIZE('Table','Table'[ISO],'Table'[Date],'Table'[Calc 2]) Var table3=SUMMARIZE('Table','Table'[ISO],'Table'[Date],'Table'[Calc 3]) Return UNION(table1,table2,table3)Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
