Show table values if they are only present in another table

[Anderrated]

I am struggling to solve this issue, my dashboard is the following

Both table A and table B are linked to "Date" which is a calendar that is filtered with a Slicer:

Date: a calendar ranging from min TableB to max TableB.

When I put my slicer to 01/01/2023 to 6/6/2023 for example, my table A and B look like this

TableA

Lot	Started Units	Date
A	100	1/1/2023
B	200	2/2/2023
C	300	3/3/2023
D	400	4/4/2023
E	500	5/5/2023
F	600	6/6/2023

Table B

Lot	Finished Units	Date
A	100	2/1/2023
B	200	2/2/2023
C	300	3/2/2023

Basically I want a third table, TableC, that will show:

Lot	Started Units	Date
A	100	1/1/2023
B	200	2/2/2023
C	300	3/3/2023

So basically it's a TableC = TableA but only showing the Lot rows present in TableB. It needs to change when I change my slicer.

I have tried to do this by applying a filtering on TableA by lot value of TableB but it's not working. What i am missing? As seen in the picture, TableC should show the same as TableA, minus row 230071. Thanks! 🙂

 

[darkinvader_ · Accepted solution]

Hi @Anderrated ,

I don't know whether you've access to make edit in Power Query. But if you have you can merge this two tables as new on "Lot" column. And it will give you your required C table, then you can connect this C table with Calendar table. I'm assuming that "Lot" column is unique (key).

Regards
Dark Invader