Filtering out data from another csv file

[KingsleyZ]

Hi,

I have 2 .csv files, 1st file has a column Source_IP the other file has a column TOR_IP.  What i'm trying to do is take the 1st file and filter out all of the TOR_IP

I tried to create a relationship between them but it won't let me because one of the columns must have unique values.  I am really new to PowerBI and i just can't seem to figure out how to do this.  It seems to me it should be rather straighforward but i'm struggling.  Help!

Thanks 

[KingsleyZ · Accepted solution]

I figured it out, I used an outer left join and merged the queries.  I was then able to use a conditional column to show if the item exsisted in the 2nd table and to write TOR if yes, and the originating country if else.

This was the post that I found the answer in.

https://community.powerbi.com/t5/Desktop/MATCH-between-2-tables/td-p/87521

Thanks guys for your help!

[v-huizhn-msft]

Hi @KingsleyZ,

Congratulations, you have resolved your issue by yourself. Please mark your solution as answer, so more people will get useful information easily.

Best Regards,
Angelia

[v-huizhn-msft]

Hi @KingsleyZ,

Please try the solution @Greg_Deckler poated, and mark it as answer if you have resolved your issue. Otherwise, please feel free to ask if you still have other issue.

Best Regards,
Angelia

[Greg_Deckler]

@KingsleyZ- Try the EXCEPT function:

https://msdn.microsoft.com/en-us/library/mt243784.aspx

You should be able to create a new table under the Modeling table and just do EXCEPT(TableA,TableB).