Forum Discussion

Winter_king94's avatar
Winter_king94
Icon for Helper I rankHelper I
6 months ago
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...
Need Help
  • krishnakanth240's avatar
    krishnakanth240
    6 months ago

    Hi Winter_king94 

    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

krishnakanth240's avatar
krishnakanth240
Icon for Super User rankSuper User
6 months ago

Hi Winter_king94 

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