Forum Discussion
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.
4 Replies
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.
