Combining/appending 2 reports from the same table into 1

[tomekm]

Hi,

I currently have 2 reports built (pointing to the same table) with 3 columns each (2 of them are the same column names; 1 column is different) that I would like to combine/union into 1 single report, based on the same “Period”, and provide the net value of the change (“Impact” column). Please see screenshot below. The second screenshot is the desired output report. How can I accomplish this?

Thanks.

[tomekm · Accepted solution]

Yes. Please see below. I'm looking to combine the 6 columns into 3 common ones (with the last one being the "net Impact" column).

Period (removals)	Removals	Impact (Removals)	Period (adds)	Adds	Impact (Adds)
Apr-2021	Removal	-5	Apr-2021	Add	1
May-2021	Removal	-8	May-2021	Add	3
Jun-2021	Removal	-9	Jun-2021	Add	6
Jul-2021	Removal	-3	Jul-2021	Add	7
Aug-2021	Removal	-1	Aug-2021	Add	2
Sep-2021	Removal	-5	Sep-2021	Add	9

[v-jingzhang · Accepted solution]

Hi @tomekm 

Create a new table with below code, then add all columns into a table visual.

Table 2 = UNION(SELECTCOLUMNS('Table',"Period",'Table'[Period (removals)],"Removals",'Table'[Removals],"Impact",'Table'[Impact (Removals)]),SELECTCOLUMNS('Table',"Period",'Table'[Period (adds)],"Removals",'Table'[Adds],"Impact",'Table'[Impact (Adds)]))

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[amitchandak]

@tomekm , Can you share source data in table format

[tomekm · Accepted solution]

Yes. Please see below. I'm looking to combine the 6 columns into 3 common ones (with the last one being the "net Impact" column).

Period (removals)	Removals	Impact (Removals)	Period (adds)	Adds	Impact (Adds)
Apr-2021	Removal	-5	Apr-2021	Add	1
May-2021	Removal	-8	May-2021	Add	3
Jun-2021	Removal	-9	Jun-2021	Add	6
Jul-2021	Removal	-3	Jul-2021	Add	7
Aug-2021	Removal	-1	Aug-2021	Add	2
Sep-2021	Removal	-5	Sep-2021	Add	9