Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@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:
@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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |