Forum Discussion
Helper IIICombining/appending 2 reports from the same table into 1
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.
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 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.
3 Replies
- amitchandak
Super User
tomekm , Can you share source data in table format
tomekmYes. 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-jingzhangCommunity Support
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.
