How to make exclusion table in Power BI

[gvg]

I am looking for a solution of this probably simple problem. I have two tables in Power BI: Inventory and Sales:

Inventory               Sales       
Item   Title            Item    Quantity
123    Soap             124     5
124    Detergent        123     8
125    Toothpaste
126    Tooth brush

How can I make a Table visual that lists items not sold. I.e. I need to return:

Item   Title
125    Toothpaste
126    Tooth brush

[piyushj]

You can use edit query option and make one parameter having first table item column should present in it. After that append both the tables and filter the item column table2 having value item2<>item1

[Vvelarde · Accepted solution]

@gvg

Hi. Please view the image:

[gvg]

Thanks Vvelarde. Can you show what kind of relationship you make here? I do not see it in the video.

[Vvelarde]

@gvg

Is One to Many (Inventory to Sales)