How to append tables and keep their original name

[Anonymous]

Hello,

I would like to append three tables (see below) but to give a particular name to the global table.

Is it possible to do that and if so how.

Imagine that I have those table

Table A

Table B

Table C

If I append table A, to table B and to table C, the end result will be the content of all those tables but with the name of the global table will be Table A.  Also, It will be possible to see the content of table B and table C but I assumes that Table A will have lost it original content which will be replaced by the content of the three tables.

What I would like to do it is to create a table let's say Table 1 which will content table A , B, C .  After that append operation, I would like to be able to see the particular content of each table.

ex:

Table 1 (Table A + Table B + Table C)

Table A

Table B

Table C

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

We can create a newquery using following formula in the Power Query Editor to meet your requirement:

let
    tableA = Table.Group(Table.AddColumn(#"Table A", "Table Name", each "Table A"), {"Table Name"}, {{"Table Content", each _, type table [Name=text, Value=number, Table Name=text]}}),
    tableB = Table.Group(Table.AddColumn(#"Table B", "Table Name", each "Table B"), {"Table Name"}, {{"Table Content", each _, type table [Name=text, Value=number, Table Name=text]}}),
    tableC = Table.Group(Table.AddColumn(#"Table C", "Table Name", each "Table C"), {"Table Name"}, {{"Table Content", each _, type table [Name=text, Value=number, Table Name=text]}}),
    Source = Table.Combine({tableA,tableB,tableC})
in
    Source

change the part of [Name=text, Value=number, Table Name=text] based on the columns in your origin table.

Then we can expand all of them or just one:

BTW, pbix as attached.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

you should able to do is using union or union and SUMMARIZE. In SUMMARIZE you can static column to give the table name

Balance Sheet = union(SUMMARIZE(Sales,Sales[Brand],"Col1",sum(Sales[Sales]),"Col2",sum(Sales[COGS]),"sort",COUNTROWS(Sales)),SUMMARIZE(Sales,Sales[Brand],"Col1",sum(Sales[Sales]),"Col2",sum(Sales[COGS]),"sort",0) )

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601