Join two matrices

[Syndicate_Admin]

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.

[Syndicate_Admin]

With union combined with selectcolumns it was great. Thank you.

[DOLEARY85]

No problem, happy to help 🙂

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Syndicate_Admin]

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.

[DOLEARY85]

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 👍

[DOLEARY85]

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 👍