Forum Discussion
Join two matrices
Hello
Would anyone know how to tell me what is the best way to get in the same matrix what I have in two?
Now I have two matrices, the data is from different tables since one table is invoice and the other credit. I want to show only a matrix but list both invoices and credits.
I have a filter that filters the two matrices.
Thank you.
5 Replies
Hi,
You could append the rows from one table to another or both to one new table using power query,
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
I already tried but this gives me many problems later, since I have to relate this new table with other tables, some tell me that the relationship can not be because there is already another relationship ... I can't remove that relationship because I use it for something else.
How about a calculated table?
If you go onto the dataview you can select new table and union them together:
Table Combined = UNION(Table1,Table2)If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
With union combined with selectcolumns it was great. Thank you.
No problem, happy to help 🙂
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
