Forum Discussion

Winter_king94's avatar
Winter_king94
Helper I
4 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
    4 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

lbendlin's avatar
lbendlin
Super User
4 months ago
I have converted an excel formula into a calculated column

Don't do that. Power BI is not Excel.  Formulate the business problem and then design a native solution based on Power BI's capabilities.

 

As krishnakanth240 mentioned one of the recommended approaches to get rid of the circular dependency is to push that column generation up into Power Query.