Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
KingsleyZ
Frequent Visitor

Filtering out data from another csv file

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 

1 ACCEPTED SOLUTION
KingsleyZ
Frequent Visitor

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!

View solution in original post

4 REPLIES 4
KingsleyZ
Frequent Visitor

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!

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
Employee
Employee

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
Super User
Super User

@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).


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.