Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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!
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
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
@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).
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |