Forum Discussion
Circular Dependency Error
Hey rachelbabcock ,
you should never use a measure inside a calculation of a calculated column, here it is also responsible for the circular dependency as the measure tries to average rows whereas the calculated column just wants to resolve the row context (please be aware that this explanation is very simplified).
if you already spend days, spend some additional hours and create sample data, that allows understanding your requirement. From my understanding, you just need to create a single table, because everything happening in power query is not relevant to understand the problem. Make sure that you recreate the same calculated columns if any are existing. Just enter data, upload the pbix to onedrive or dropbox, and share the link.
Regards,
Tom
Hey rachelbabcock ,
you should never use a measure inside a calculation of a calculated column, here it is also responsible for the circular dependency as the measure tries to average rows whereas the calculated column just wants to resolve the row context (please be aware that this explanation is very simplified).
if you already spend days, spend some additional hours and create sample data, that allows understanding your requirement. From my understanding, you just need to create a single table, because everything happening in power query is not relevant to understand the problem. Make sure that you recreate the same calculated columns if any are existing. Just enter data, upload the pbix to onedrive or dropbox, and share the link.
Regards,
Tom
Hey Tom,
I think I just needed to look at it with fresh eyes and fresh data. When I built a sample data set to post here, the process actually worked fine. I went back into my original dataset and initially just started from scratch. Not quite sure what was wrong before but just glad to have it working. Thanks!