Page 500 - Computer Software Application TP - Volume 1
P. 500
COMPUTER SOFTWARE APPLICATION - CITS
// Add a new column “Sum” by adding the values from the referenced cells
CombinedQuery = Table.AddColumn(Source, “Sum”, each [Principal Amount] + [Interest])
• Excel.CurrentWorkbook(): Function that references the entire current workbook.
• {[Name=”Table13_2”]}: Accesses a specific table in the workbook named “Table13_2.”
• [Content]: Retrieves the content of the “Table13_2” table.
Add a New Column “Sum”
// Add a new column “Sum” by adding the values from the referenced cells
CombinedQuery = Table.AddColumn(Source, “Sum”, each [Principal Amount] + [Interest])
• Table.AddColumn(Source, “Sum”, each [Principal Amount] + [Interest]): Adds a new column named
“Sum” to the Source table.
• each [Principal Amount] + [Interest]: Defines the operation to be performed in each row of the new “Sum”
column. It adds the values from the “Principal Amount” and “Interest” columns.
• Click “Close & Apply” to apply the changes and load the data into your Excel workbook or Power BI report.
485
CITS : IT & ITES - Computer Software Application - Exercise 76
