How to sum multiple arrays

Hi Anonymous ,

According to your description, here is my solution.

It may be not achievable to add a row to each table to show the sum of each column of three tables. Because you cannot add calculated columns or measures to rows and if you use calculated columns or measues to create a new table, it cannot be appended to other tables with Power Query.

I suggest that you can append three tables first and then display the totals. Please follow these steps.

Then merge first three columns.

Make sure that each column is in number format not text(a summing symbol appears next to the column header), otherwise you cannot get the correct total.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.