Power Query sum two columns from different tables

[tiredofit]

I have loaded two sales data tables into the PQ editor.

Each table only contains a single column of data.

One is called April and the other May.

All I want is to create a new table containing a single column called Total, which sums each row within the two tables.

How can this be achieved?

Thanks

 

[Kerryx]

If the rows have some matching component e.g. and ID then merge and SUm , if they don't add an index column to both table and merge using the Index as the ID, then sum columns as needed

 

[Kerryx]

let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"May", Int64.Type}}),
    #"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 0, 1, Int64.Type),
    #"Merged Queries" = Table.NestedJoin(#"Added Index", {"Index"}, Table1, {"Index"}, "Table1", JoinKind.LeftOuter),
    #"Expanded Table1" = Table.ExpandTableColumn(#"Merged Queries", "Table1", {"April", "Index"}, {"Table1.April", "Table1.Index"}),
    #"Added Custom" = Table.AddColumn(#"Expanded Table1", "SUM", each [May]+[Table1.April]),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Table1.Index", "Index", "Table1.April", "May"})
in
    #"Removed Columns"

Book1
	A	B	C
1	April		May
2	1		4
3	2		5
4	3		6
Sheet1

Book1
	A
1	SUM
2	5
3	7
4	9
SUM

 

[tiredofit]

If the rows have some matching component e.g. and ID then merge and SUm , if they don't add an index column to both table and merge using the Index as the ID, then sum columns as needed

I'm afraid I not sure what you mean.

This is what I have:

The OK button is greyed out.

 

[Kerryx]

Paste the code above into advanced editor and you can see the applied steps
Looking at the above you will need to add Index Column to bothe tables like below

When you Merge then use the Index Column to keep the rows aligned that you want to sum(you need to select the column ) then you will be able to click on OK

 

[Kerryx]

Add index column by

 

[tiredofit]

Add index column by
View attachment 94003

I manually added an Index column to both tables, then pasted your code into the Advanced Editor.

When I pressed Enter, I got this:

 

[Kerryx]

Ok if you are using the code you do not need to add the index columns manually as the code has that in it.
I was explaining how to add the index column as it looked like you wanted to do it manually yourself. the error is showing because it now sees additional column added.

 

[Kerryx]

Here is file example
Example

 

[tiredofit]

Here is file example
Example

Thanks, have just downloaded your example.

However, my two tables, April and May are located on different worksheets within the same workbook.

Does that change things or will it work equally well?