Forum Discussion

lostpowerbidev's avatar
lostpowerbidev
New Member
1 year ago
Solved

Need help with Circular Dependency Workaround

Hi all, I'm working on a shipment consolidation model in Power BI and need help building a calculated column that tracks consolidation logic after a reset. I have been banging my head on the wall si...
  • samratpbi's avatar
    1 year ago

    Hi, not very sure about the data what you have in the excel and in the main table, however looking into the details it seems you are first deriving the 1st screenshot in dax and then trying to do the 2nd one. You can do one thing, 1st step try to achieve using power query. In that way, there will not be any circular dependency.

     

    If this helps to resolve your problem, then please mark it as solution, thanks