Summation of a column on a matching criteria from another column in same table

[Anonymous]

Hi 

I have a table with following structure 

Month	Source	Price	%age	%AgePrice
Jun-20	A	1.2	48	0.576
Jul-20	A	1.3	48	0.624
Aug-20	A	1.4	48	0.672
Jul-20	B	1.7	20	0.34
Aug-20	B	1.78	20	0.356
Jul-20	C	1.7	20	0.34
Aug-20	C	1.8	20	0.36
Sep-20	C	1.78	20	0.356

Where %age Price is a calculated Column which is Price * %age 

I have to now calculate another column which should be sum of %agePrice for all different sources matching on a Month 

Such that my output be like 

Required Sum price	Month
0.576	Jun-20
1.304	Jul-20
1.388	Aug-20
0.356	Sep-20

e.g. For June 2020 , Required Sum price = =E2

JUL 2020 - =E3+E5+E7 and so on. Is there a way to do this in PowerBI Query 

Thanks for help in advance 

[v-juanli-msft]

Hi @Anonymous 

Add columns to a matrix directly.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Maggie 

I have created an appended table with data from different tables consisting of various sources "Table 1". Now , i need to calculate another column "Required Sum price" which is Sum of %age Prices from all Sources for a given Month. I am stuck at how to calculate this sum matching on month and make this new column part of the same appended table such that it could all be represnted in a matrix. 

Hope that clarifies

Thanks

[Anonymous]

@v-juanli-msft , Team 

Could you please help with the tricks to how this summation could be done. I am new to PowerBI and your help will be appreciated . Thanks 

[Anonymous · Accepted solution]

All , i have been able solve this myself by using Summarize function, All i did was Summarized the source table data into a new Table and Sum it on the prices that I want summation on . I will now mere this table along with the source table such that complete set  of data could be represented in a Matrix.

Thanks

[Anonymous]

I would rather like to have new calculated values appended in the same Source table , With Source being as D , Month, %age price as 1 and then calculated price as summation of values from different rows. Given this needs to represented in a matrix eventually, i feel would be  the best way to do it ?