Forum Discussion
Summarizing two different tables
You can use Append to achieve this. Select Append as new Queries, Append Table B on the Table A and then You can do GROUPBY,
Group by Date, Operation Sum and Column is Euro. This will give you the desired result. See the attached screenshot.
Append as new queriesGroupbyFinal outcome
Hi david2，
That combining two tables can be easily achieved using DAX, please refer to below formulas to create new tables:
Table1 = UNION(TableA,TableB) TableC = SUMMARIZE(Table1,Table1[Date],"Costs",SUM(Table1[Costs]))
If you have any other question, please feel free to ask.
Best regards,
Yuliana Gu
You can use Append to achieve this. Select Append as new Queries, Append Table B on the Table A and then You can do GROUPBY,
Group by Date, Operation Sum and Column is Euro. This will give you the desired result. See the attached screenshot.
Append as new queriesGroupbyFinal outcome
I have a similar query, but I would like to see values from Table A and Table B in seperate columns