Table

AddColumns

Returns a copy of a table with extra calculated columns. The source is unchanged.

Syntax

AddColumns(Table, ColumnName1, Formula1 [, ColumnName2, Formula2, ...])

=AddColumns(Table({Item: "Pen", Qty: 2, Price: 1.5}), Total, Qty * Price)

The table with a Total column (3)