Forum Discussion

jvs5899's avatar
jvs5899
Frequent Visitor
2 years ago
Solved

Exclusion List to modify SQL Query?

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...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    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)

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

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)