Replace Value in columns whic names appear on a list

[Anonymous]

Hi All,

I want to replace a value in some columns but the number and name of the columns change each time, but I can have them on a list or a differente table

For example;

I want to use this replace formula

Replaceformula

But intead of writing {"201111", "201112", "201201", "201202", "201203", "201204", "201205", "201206", "201207", "201208"} in the "columnstosearch" par of the function, I wan it to take all the values in the list

ListFormula

Thank you all

[Anonymous]

try this scheme

let
tab=  Table.FromRecords({
        [A = 3, B = 2,C=1], 
        [A = 2, B = 10,C=888],
        [A = 22, B = 2,C=12]
    }),

cols={"A","B"},
newtab=Table.TransformColumns(tab,List.Zip({cols,List.Repeat({each  if _=2 then 999 else _},List.Count(cols))}))

in
newtab