Forum Discussion
Solved
Remove circular dependency from calculated column
Hello, I have converted an excel formula into a calculated column. This calculated column (Lookup Customer Sector) produces the exact results I need, which is combining the sector from multiple table...
Because calculated column uses LOOKUPVALUE across tables that are related to same table creating a dependency loop.
So, do not use a calculated column and convert it into a measure or power query column. Move this logic to power query, merge tables step by step like your VAR logic and create the column there
thank you! I will work on moving this over to Power Query
You're welcome Winter_king94! Sure