I’ll take a look and see what I can come up with. Coincidentally, I was just reviewing the Debugging and Optimization chapter of the Greg Deckler book I mentioned the other day, and he’s got a section on addressing circular dependencies.
Don’t know if a Power Query-based solution might be acceptable, but I’ve been playing around a little with some of the recursive concepts from this video:
Will get back to you later this evening…
- Brian