Creating a combined summary table

Question

Hi all,&nbsp;I have a table such as the example below. On one column I have the account for the acquisition value of an asset, the next is the account used for depreciation, the next is the actual acquisition value in EUR, and the last one the depreciation value in EUR.Company NameAccount - Acquisition valueAccount - Depreciation Amount - Acquisition valueAmount - DepreciationXAV101AD101500250XAV102AD1021200800XAV101AD101700200XAV103AD103750300XAV102AD102900500XAV101AD101200200&nbsp;I need to somehow create a summary like this and make it dynamic as more accounts and data gets added to the model.Company NameAccountValueXAV1011400XAV1022100XAV103750XAD101650XAD1021300XAD103300&nbsp;I was thinking of using Power Query M for this. Not sure if its the best solution.&nbsp;Thanks in advance,JIRAMON

v-zhangti · Accepted Answer

Hi,&nbsp;JIRAMON&nbsp;
&nbsp;
You can try the following methods.Table:
New table = 
Var _table1=SUMMARIZE('Table','Table'[Company Name],'Table'[Account - Acquisition value],"Value",SUM('Table'[Amount - Acquisition value]))
Var _table2=SUMMARIZE('Table','Table'[Company Name],'Table'[Account - Depreciation],"Value",SUM('Table'[Amount - Depreciation]))
Return
UNION(_table1,_table2)

Is this the result you expect?
&nbsp;
Best Regards,
Community Support Team _Charlotte
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Creating a combined summary table

2 Replies

Related content

Tables combine

Power BI July 2026 Feature Summary

combine summary table

Folder Combine Wizard creates sample file queries but does not generate final combined query

Schedule an email of AI created summary of a semantic model

Company Name	Account - Acquisition value	Account - Depreciation	Amount - Acquisition value	Amount - Depreciation
X	AV101	AD101	500	250
X	AV102	AD102	1200	800
X	AV101	AD101	700	200
X	AV103	AD103	750	300
X	AV102	AD102	900	500
X	AV101	AD101	200	200

Company Name	Account	Value
X	AV101	1400
X	AV102	2100
X	AV103	750
X	AD101	650
X	AD102	1300
X	AD103	300