Forum Discussion
Need help with Circular Dependency Workaround
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
Community SupportThank you for submitting your question to the Microsoft Fabric Community Forum.
As samratpbi suggested, move that first step of logic (cumulative days, reset identification, and related calculations) into Power Query instead of building it entirely with calculated columns. By doing this, the table that loads into your model already contains the reset and cumulative information, which removes the circular dependency issue and makes the DAX model simpler and more efficient.
I hope this information is helpful. . If you have any further questions, please let us know. we can assist you further.
Regards,
Microsoft Fabric Community Support Team.