Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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.
You may try to use UNION Function.
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?
First check the RELATED Function and LOOKUPVALUE Function.
Hi @eltorr0
What you could then do is in the Query Editor Merge the tables Matrix1 and Matrix 2 joining on the Ratio Column.
User | Count |
---|---|
94 | |
77 | |
71 | |
62 | |
58 |
User | Count |
---|---|
110 | |
103 | |
84 | |
65 | |
62 |