Forum Discussion
Filtering out data from another csv file
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
