Creating a combined summary table

[JIRAMON]

Hi all,

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 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

I need to somehow create a summary like this and make it dynamic as more accounts and data gets added to the model.

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

I was thinking of using Power Query M for this. Not sure if its the best solution.

Thanks in advance,

JIRAMON

[JIRAMON]

Thank you very much! This is exactly what I needed! 🙂

[v-zhangti · Accepted solution]

Hi, @JIRAMON 

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?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.