Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
206
Views
Topic starter
Hello, I have 3 tables:
In table 1 I have the sum price of the product that name is 'ORANGE". The number of product is 201619038.
name | number | sum |
orange | 201619038 | 95,608.13 |
In table 2 I have the sum price of the same product that name 'ORANGE" but it appears in two lines. The total result is the same 95,608.13.
name | number | sum |
orange | 96395665 | 91,575.50 |
orange | 967844 | 4,032.63 |
total | 95,608.13 |
In table 3 I have Conversion Table for number of product:
name | the number in table 1 | the number in table 2 |
orange | 201619038 | 96395665 |
orange | 201619038 | 967844 |
The question is: how can I do the merge of table 1 & 2 if I have to get to the result like this:
name | from table 1number | sum | from table 2 number | sum | difference |
orange | 201619038 | 95,608.13 | 96395665 | 91,575.50 | 4,032.63 |
orange | 201619038 | 967844 | 4,032.63 | -4,032.63 |
Thank you in advance
Posted : 26/08/2019 3:40 am
Hi Irena,
Please see the attached file. However, the sum of 95,608.13 relates to the table from 1number 201619038, not the number in table two; 96395665 and therefore it is on both rows in the final table. There is no logical way you can avoid this for the second row and return a blank, as you have in your example.
Mynda
Posted : 26/08/2019 6:49 pm
Topic starter
Thank you!
Posted : 27/08/2019 3:25 am