Add a column into PowerQuery with a custom formula

00:00 Add a column with formula within the Power Query editor
00:15 Add an average column within PowerQuery via arithmetic
00:25 Import the table into Power Query
00:32 Add column in PowerQuery
00:42 Name the new column
01:04 Create a simple average formula column
01:20 Confirm that the formula works for PowerQuery

Add a column into PowerQuery with your own formula/ function/ arithmetic that makes use of the existing columns. In this case we created a simple average column but it can be anything in much the same way you would add columns into Excel.