Forum Discussion
Winter_king94
Helper I
Helper IRemove 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
Winter_king94Helper I
Helper Ithank you! I will work on moving this over to Power Query
- krishnakanth240
Super User
You're welcome Winter_king94! Sure