Circular Dependency detected issue

[Qazybek]

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?

[Greg_Deckler]

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...

[Qazybek]

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

[Greg_Deckler · Accepted solution]

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

[Qazybek]

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

[MattAllington]

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/ 

[Qazybek]

Greg, Matt, Thank you very much!

[Qazybek]

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

[SonLeThai]

Do you solve this case? can you share with me? i get the same issue...:(... Please help me solution.