Multiply two columns without adding a new Column RRS feed

  • Question

  • Hi all,

    I would like to multiply two columns in PowerQuery. I know, it's simply by adding a new Column like this:

     #"Added Custom" = Table.AddColumn(#"Changed Type", "Act2", each [Act]*[Vorzeichen])

    The Problem is, I want to transform one of the existing columns without adding a new one. Something like this:

    #"Multiplied Column"= Table.TransformColumns(#"Changed Type", {{"Act", each [Act]*[Vorzeichen]}})

    or this:

    #"Multiplied Column" = Table.TransformColumns(#"Changed Type", {{"Act", each List.Product({_, [Vorzeichen]})}})

    But that doesn't work. Where is the mistake and how does it work?

    Thanks a lot in advance


    Friday, October 27, 2017 9:17 AM


All replies