Forum Discussion

smitpau's avatar
smitpau
Helper I
5 years ago
Solved

Power M - Cyclic Reference encountered during evaluation

Hi,   I'm trying to replace values based on the column indexed position using Table.ColumnNames.  If I try the code below replacing the actual column name with the Table.ColumnNames version for so...
Need Help
tex628's avatar
tex628
Community Champion
5 years ago

You need to replace the table references with tables that occur before the transformation. Like this:

= Table.ReplaceValue(#"Removed Columns",null,"0",Replacer.ReplaceValue,Table.ColumnNames(#"Removed Columns")


If you want to reference GPL Adjustments 4 and 5 you need to make sure you reference them at a step where your current table has not affected the transformation stages yet. 

Br,
J




smitpau's avatar
smitpau
Helper I
5 years ago

Ah okay I think I see so it has to flow from the last transformation. 

 

So it would be like

 

{Table.ColumnNames(#"Removed Columns"){4}, Table.ColumnName(#"Removed Columns"){5}}