Forum Discussion

monojchakrab's avatar
monojchakrab
Icon for Resolver III rankResolver III
3 years ago
Solved

Insert column in Tables, using values from another column

Hiya good people,   I am trying to solve, possibly a wierd problem. I have a table as below :   What I want to do is as follows :   In each of the table under the [Data] column, i want to...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    NewStep=Table.ReplaceValue(PreviousStepName,each [Account],"",(x,y,z)=>Table.AddColumn(x,"Account",each y),{"Data"})

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

NewStep=Table.ReplaceValue(PreviousStepName,each [Account],"",(x,y,z)=>Table.AddColumn(x,"Account",each y),{"Data"})