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
Super UserHi, 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