create visual that show records that are in table A but not in table B: how to do it?

[tvanover]

hi,

I am running a warehouse where I need to track items that are at risk of expiring.

to do that, I want to make:

1) a list of all items currently on stock -> table A

2) a list of all items that have been ordered in the last 6 months -> table B

show only records that are in table A but not in table B

How can I do that?

thanks,

tom

[v-yangliu-msft · Accepted solution]

Hi  @tvanover  ,

According to your description, I create some data:

Table A: Dates from 2020.6.1 to 2021.4.3

Table B: Dates from 2020.11.1 to 2021.4.3

Here are the steps you can follow：

1. Create measrue.

Measure =
IF(
    MAX('TableA'[date])<MIN('TableB'[date])||MAX('TableA'[date])>MAX('TableB'[date]),1,0)

2. Place the measure in the Filter, select is =1, Apply filter.

3. Result.

Table A shows that there is no data from Table B

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.