cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Qazybek Frequent Visitor
Frequent Visitor

Circular Dependency detected issue

Hello all,

 

Here is a link to my demo-table. I want to create the same table using DAX in PowerPivot Data Model but can't figure out how. The problem is a circular dependency. Can someone please help?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Circular Dependency detected issue

In your query, duplicate your F column. Use that column to calculate C.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


7 REPLIES 7
Qazybek Frequent Visitor
Frequent Visitor

Re: Circular Dependency detected issue

Here is what I tried to do. Can anyone update?

 

Everything is in the Data Model. I need to adjust Assets BoY after Injection column

Super User
Super User

Re: Circular Dependency detected issue

Yes, that is going to create a circular dependency, not sure what else to say. E comes from C, F comes from C and E and C depends on F, so...


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Qazybek Frequent Visitor
Frequent Visitor

Re: Circular Dependency detected issue

Thank you for reviewing. Any chance to avoid circular dependency here?

Super User
Super User

Re: Circular Dependency detected issue

In your query, duplicate your F column. Use that column to calculate C.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Qazybek Frequent Visitor
Frequent Visitor

Re: Circular Dependency detected issue

Do you mean in PowerQuery? I don't see this column there Smiley Sad It should be calculated one

Super User
Super User

Re: Circular Dependency detected issue

You should listen to Greg.  Column C points to F and F points to C.  It doesn't matter that the rows are different. it works column by column, not row by row.  I suspect you may be able to do it with a combination of combining the formulas into 1 or 2 columns, plus using this technique I show here. https://exceleratorbi.com.au/user-specified-growth-investment-using-power-bi/ 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Qazybek Frequent Visitor
Frequent Visitor

Re: Circular Dependency detected issue

Greg, Matt, Thank you very much!