Forum Discussion
Solved
Power Bi Remove Rows Based on Category found in a related table.
Hi all. I do a daily download of a CSV file with new tenders from a government site. I am only interested in particular categories of tenders so want to remove any rows with categories that I am not...
No problem.
- Open PowerQuery
- From the top menu select New Source > Blank Query
- From the top menu select Advanced Editor and paste the Category Table code in.
- Rename the query to Category Table
- Repeat for the second table using the Tenders Table table, rename table as Tenders Table.
This will show you the steps that I have taken to solve your issue, if you have an specific questions let me know. Happy to point you in the right direction.
James
Thank you for you response. I don't know how to use what you have given me.
No problem.
- Open PowerQuery
- From the top menu select New Source > Blank Query
- From the top menu select Advanced Editor and paste the Category Table code in.
- Rename the query to Category Table
- Repeat for the second table using the Tenders Table table, rename table as Tenders Table.
This will show you the steps that I have taken to solve your issue, if you have an specific questions let me know. Happy to point you in the right direction.
James