Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Transformation to Multiply and Divide in the Same Step

  Guys, what is wrong with this script? = Table.TransformColumns(#"Expanded Table Column1", {{"Avg Talk", each _ *[Interactions]/ 86400, type number}})   What I aim to is to multiply column: Avg ...
Need Help
  • xzmiche's avatar
    xzmiche
    5 years ago

    Table.TransformColumns can access only each column in isolation. We have to use below walk around method (this solution is from power-query-transform-a-column-based-on-another-column ðŸ˜ž 

     

     

    = Table.FromRecords(Table.TransformRows(#"Changed Type", (r)=> Record.TransformFields(r,{{"Avg Talk", each _ * r[Interactions]/86400}})))

     

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

 

Problem is with the replacing method that you could apply the step in 1 column only, I was hoping to apply in many columns thru 1 step.

xzmiche's avatar
xzmiche
Icon for Resolver I rankResolver I
5 years ago

Table.TransformColumns can access only each column in isolation. We have to use below walk around method (this solution is from power-query-transform-a-column-based-on-another-column ðŸ˜ž 

 

 

= Table.FromRecords(Table.TransformRows(#"Changed Type", (r)=> Record.TransformFields(r,{{"Avg Talk", each _ * r[Interactions]/86400}})))

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Works perfectly, thanks