Exclusion List to modify SQL Query?

[jvs5899]

Hello,

I am working on a very large project where the last requested feature is the ability to designate certain rows of one of the data tables to be excluded from all other calculations. Make it as through it didn't exist. Given that this dashboard is going to be updated frequently and it has a lot of calculations going on, I am wondering if it would be possible to create a manual entry table that I can use to exclude rows when we do the SQL query. I have a unique identifier, but I don't know if it is possible to exclude the query this way or the syntax to do so. 

Has anyone ever had to do something like this?

Thank you!

[lbendlin · Accepted solution]

yes, many times. Create your reference table with the exceptions. Join it in a 1:1 relationship with your original data table. In that original table create a calculated column that pulls in the RELATED ID from the other table.  Filter your original table for that new column to only contain BLANK()

(Better do that in Power Query as a 1:1 relationship, especially when it is not covering, comes with a lot of baggage)