Search notes:

Power Query M formula language standard library: Table.CombineColumns

The following example mulitplies the values of val 1 with val 2 and stores the result in the column mult. After the operation, the columns val 1 and val 2 will be removed: 
let
   tab = #table(
    { "id", "val 1", "val 2"}, {
     {  1 ,      6 ,      4 },
     {  2 ,      2 ,      3 },
     {  3 ,      3 ,      5 }
   }),
   tab_ = Table.CombineColumns(tab,
     {"val 1", "val 2"},
      each _{0} * _{1},
     "mult"
   )
in
   tab_
The result is 
   id   mult
   1    24
   2    6
   3    15

See also

The Power Query standard library and its function Table.AddColumn

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/Microsof...', 1758209551, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/Microsoft/Power-Query/M-formula/standard-library/Type/CombineColumns(57): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78