Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |