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
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