Forum Discussion
Power M - Cyclic Reference encountered during evaluation
Thanks.
Think you were right the issue was the source was not correct.
I followed the video below, checked the syntax of the code for example below and it works.
Table.ReplaceValue(#"Removed Columns",null,"0",Replacer.ReplaceValue,{Table.ColumnNames(#"Removed Columns"){3}, Table.ColumnNames(#"Removed Columns"){4}, Table.ColumnNames(#"Removed Columns"){5}})
Sorry, it doesn't appear to be as easy as i thought. I cant seem to figure out how to reference earlier steps in other queries.
Essentially you can't reference the final step in GPL Adjustments because something in those queries is dependant on the querie you want to transform.
What i wanted to do is reference the GPL queries before they become dependant but I think i need some more time to see how you reference correctly.
Another solution that isn't as nice is breaking up the GPL queries before they become dependant by creating a new reference query just before you do the dependant transformation.
Then you can turn off the load of the original queries, and then reference them in the replace transform without any errors.
/ J