Forum Discussion
Circular Dependency
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.
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.