can Power BI create new column with aggregation based on groups?

[sagdec12]

Hi all, I have a question about the groupby/summarizecolumns question. I understand that we can perform groupby to new table. Suppose I have a table but I want the sum value to be added to the current table. For example, I have

A	1
A	2
B	3
B	4

I want a new column like:

A	1	3
A	2	3
B	3	7
B	4	7

is that possible?

Thank you very much

[amitchandak · Accepted solution]

@sagdec12 , A new column

Column 3=  sumx(filter(Table, [Column1] = earlier([Column1]) ), [Column 2])

[sagdec12]

thanks a lot!