Forum Discussion
How to sum multiple arrays
Hello everyone,
I need your help because I have the following problem: I have three different tables like this:
Each table has a total and I'd like a row below these three tables that add up to the three totals above. To be clearer, for example I want this line to total the column BI = 2,746,000 + 40,000; KIBO = 9,003,556 + 3,325,000 + 885,000 (= 13,213,556); etc
Any idea how I could do that?
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 _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
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 _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.