Forum Discussion
Circular Dependency
Hi Guys, I'm facing a circular depedency error. Here is the background: I have to create a calculated column, which has the logic... if the month number is 1 then a result from a column imported f...
this is the issue here... 1st created column depends upon 2nd created col...and the 2nd created col depend on the 1st... its like a=b+c where b=a+d... where a,b,c,d are col to be created, so how do i do it in power query.
this won't work like that, you need to have a place to start with that is available, you can't reference a column that doesn't exists to be the value.
Thanks...
Is there a way to create an instance of the col that does not exist... because this formula of inter dependency of col works in MS- Excel, but with a warning. So is there a way to replicate this in power bi.