Sum of column to rows of new table

[mtanner]

Hi all

Is there a way to create a new table with each row representing the total sum value of the original table's columns?

By way of example, Table A is the original table and Table B is the desired outcome. 

Table A

Column A	Column B	Column C
1	2	6
2	5	4
4	7	5
5	3	1
7	2	6
8	1	5
27	20	27

Table B

Column A	27
Column B	20
Column C	27

Thanks in advance

[v-yulgu-msft · Accepted solution]

Hi @mtanner,

In Query Editor, duplicate the source table TableA first. In the duplicated table, choose ColumnA, ColumnB and ColumnC, click "Unpivot columns" to convert table structure. 

Best regards,

Yuliana Gu

[Anonymous]

Hi @v-yulgu-msft , can you link the 2 tables. E.g. if it there was a column 4 with cities so that from the calculated table a slicer can pull values if each city?

---

@v-yulgu-msft wrote:

Hi @mtanner,

In Query Editor, duplicate the source table TableA first. In the duplicated table, choose ColumnA, ColumnB and ColumnC, click "Unpivot columns" to convert table structure. 

Best regards,

Yuliana Gu

---

[Zubair_Muhammad]

@mtanner 

You can use a calculated table from modelling tab as

calculated Table =
UNION (
    ROW ( "Column", "ColumnA", "Sum", SUM ( TableA[Column A] ) ),
    ROW ( "Column", "ColumnB", "Sum", SUM ( TableA[Column B] ) )
)