Forum Discussion
Merge Queries Help
Hello, I am looking for help in merging two tables. I don't know what join will achieve the following:
You need an additional element to differenciate why the values of C are different. Otherwise both C values from table one will join to the C value of table two.
6 Replies
The reason this doesn't work, is that the D and E won't match now.
You need an additional element to differenciate why the values of C are different. Otherwise both C values from table one will join to the C value of table two.
In my case, the C's are just different quantities. So I bought 2 C's in table one and sold 1 C in table two. I want to show that I still have one left over.
Hmmm. Maybe create a Product Dim table with all the unique values of your products ( A, B, C, D, etc. ). Create a relationship between table one ( Bought ) and table two ( sold ). Create a measure, Available Qty = SUM( table1[bought]) - SUM( table2[sold])
???
