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...
At power query level, I think we cannot create calculated columns based on another calculated columns. Column can only be created based on columns which are imported from data source.
yes, exactly so create the first created column in power query.
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.