Difference between two matrix tables

[eltorr0]

Hi,

I'm trying to recreate an existing excel template that provides the difference between two tables.

I created two separate matrix tables, now i'm looking to create a third matrix table that provides the result of subtracting values from matrix 1 and matrix 2. 

Which would be the best way to create that third matrix showing the difference?

the two matrix have unique relationship to the row and column values, therefore a measure subtracting values from matrix 1 and 2 would not work.  Is there an alternative way to  creating this 3rd matrix table?

[GilbertQ]

Hi @eltorr0

Can you please put up a sample of the data you are working with?

You will require to have some type of common column between the different matrix tables, so that you know which values to subtract from each other.

[eltorr0]

Hi @GilbertQ,

the rows and columns have the same name, see sample screenshot:

[v-chuncz-msft]

@eltorr0,

You may try to use UNION Function.

[eltorr0]

Each table has a two separate relationships for the Ratio and Distance, the values are stored on a common data table.  

Any suggestion on getting it to work using this type of relationship?

[v-chuncz-msft]

@eltorr0,

First check the RELATED Function and LOOKUPVALUE Function.

[GilbertQ]

Hi @eltorr0

What you could then do is in the Query Editor Merge the tables Matrix1 and Matrix 2 joining on the Ratio Column.