Forum Discussion
Solved
Using column from one query in source of another query
I have a query where one of the columns in the results, is a list of table names. I want to query ANOTHER source, using the distinct values of those tables, as a filter. I have created the filter b...
Short answer: Don't do that. You will never get this past the formula firewall monster.
Long answer: You need to keep everything inside a single partition, and you need to obfuscate your sources. Lastly you may need to use Expression.Evaluate with scope bending. (If these words sound like gibberish to you then I highly recommend you consume Ben Gribaudo's Primer.)
Thank you, that is some very good advice. I will go through that primer.