Difference between two matrix tables

Question

Hi,&nbsp;I'm trying to recreate an existing excel template that provides the difference between two tables.&nbsp;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.&nbsp;&nbsp;Which would be the best way to create that third matrix showing the difference?&nbsp;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. &nbsp;Is there an alternative way to &nbsp;creating this 3rd matrix table?

gilbertq · Answer

Hi&nbsp;eltorr0&nbsp;Can you please put up a sample of the data you are working with?&nbsp;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 · Answer

Hi&nbsp;GilbertQ,the rows and columns have the same name, see sample screenshot:&nbsp;

gilbertq · Answer

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

v-chuncz-msft · Answer

eltorr0,
&nbsp;
You may try to use UNION Function.
&nbsp;

eltorr0 · Answer

Each table has a two separate relationships for the Ratio and Distance, the values are stored on a common data table. &nbsp;Any suggestion on getting it to work using this type of relationship?&nbsp;&nbsp;

Forum Discussion

Difference between two matrix tables

6 Replies

Related content

Handle AverageX on different granularities matrix drilldown

Matrix Show Different Hierarchy Levels

Matrix Showing Difference Between Two Years

Matrix table

Different schema into different destination