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.
2 Replies
You 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
