Calculte Total Amount to date for each Month by Product

[VFPowerBI]

Greeting Community ,

             I have an exemple of data  of table : 

Product	QTY	Date
P1	12	2021-5
P1	15	2021-6
P1	16	2021-7

I want to get a column or a table containing the sum of the current month of each row and all the previous months  : 

Product	QTY	Date
P1	12	2021-5
P1	17	2021-6
P1	34	2021-7

for n Product and  n previous Month/Year

Best Regards and Thank You for you Help 

[amitchandak · Accepted solution]

@VFPowerBI , Not sure how 12 + 15 =  17.

But try a new column like

sumx(filter(Table, [product] =earlier([product]) && [Date] <=earlier([Date])),[QTY])

[VFPowerBI]

Thank you it worked .

        Yes, 12+15 = 27 my bad