Forum Discussion
adding columns whose values are also based on scaling values in different table
Hello there! Have 2 tables (PVprod and StrutturaCER). I need to add new columns named "Pn" (n=1,2,...) to first table PVprod. Pn = reference column IRR * a scaling coefficient PVnew[n] taken fro...
wdx223_Daniel
Community Champion
Community ChampionM Code
=Table.FromRecords(Table.TransformRows(PVprod,each Record.TransformFields(_,List.Transform(List.Position(StrutturaCER[PVnew]),(r)=>{"P"&Text.From(r),(x)=>[IRR]*StrutturaCER[PVnew]{r}}),2)))
Hi, thanks but getting this error. Seems a "ciclic error during evaluation"
- wdx223_Daniel
it's not a formula in Custom Column
it's a whole step code, try to delete Table.AddColumn outside
