How to obtain the sum of a column in Power Query

[gianmarco]

Dear All,

I have the following table in Power Query.

Code	Value
125	2500
999	2400
356	1700
224	3600
225	3800

I need to create a new column in Power Query which gives back the total of column Value for each row.

Desired table:

Code	Value	Valute Total
125	2500	14000
999	2400	14000
356	1700	14000
224	3600	14000
225	3800	14000

I know that I can manage this through a calculated column but I need it to be in Power Query..

thanks a lot

[parry2k · Accepted solution]

@gianmarco add a new column in PQ using the following M code

List.Sum(#"<Previous Step Name"[Value])