Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

ReplaceValue for multiple columns

Hi guys,   I would appreciate some hints on how to solve a problem I'm currently facing. The goal is to replace values for multiple colums dynamically.   In case the Column "ACC (Lx)" is null, it...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

    =Table.FromRecords(Table.TransformRows(#"Converted to Table",each let a=Record.ToTable(_) in Record.FromTable(Table.ReplaceValue(a,each [Value],each [Name],(x,y,z)=>x??a{[Name=z&" (v)"]}?[Value]?,{"Value"}))))

Anonymous's avatar
Anonymous
Not applicable
4 years ago

thanks wdx223_Daniel