Forum Discussion
Two matrix merge into single matrix table
Had anyone know how to merge two matrix table into single matrix table OR how to add a new column in one of the matrix table in order to make the connection? Thank you for advance.
johnyip
Solution Sage
Solution SageYou cannot "merge" visualization on the report page.
If you intend to "merge" the matrix for further use, consider using calculated table.
Thank you for your quick reply.
I am beginner of power bi and Dax. Can you teach me how to do it?
Currently I had two tables:
Table 1 column: Customer, Date, Purchased Amount
Table 2 column: Customer, Date, Owned Amount
I want total up the each customer purchased and owned amount
Note: Each customer had different purchased and owned transaction in different date