Forum Discussion
Remove multiple lines on the table based on a blacklist table
Hello everyone, I'm new to Power BI, so I hope you guys can help me. I have a big table, and one of the fields contains information that I need to remove (not all the lines), on the other hand, I have a "blacklist" table, so I want to use the blacklist table to filter the main table and remove all the lines which match the blacklist. How can I get that? Thanks in advance for your support
HelpNeeded21 - Welcome. To do that you will want to use a Merge query and use a Left or Right Anti join. You could also do it in DAX using EXCEPT function.
Also, since I see you are a New Member, just for reference:
1 Reply
- Greg_Deckler
Community Champion
HelpNeeded21 - Welcome. To do that you will want to use a Merge query and use a Left or Right Anti join. You could also do it in DAX using EXCEPT function.
Also, since I see you are a New Member, just for reference: