POWER QUERY (relations)

Hi,

Sorry my english mistakes

I have two tables with same head columns but three.

1 TABLE: Data, location, job position and cost salaries
2 TABLE: Data, location and total sales

I use 1 TABLE as main table and from the second table I only want the total sales per day information.

If a merge both tables I get a lot duplicate rows from the column sales (TABLE 2).

If append the tables the result table is correct.

But now IŽd like to work with percentages and I cannot.

I would like to know how can I put together both tables in order to have percentages results.

As you can see I a bit new with PQ, PP and etc.

IŽd apreciate very much your support.

Regards