Cumulative Sales by month 1, 2, 3 etc

[hemann]

Hi All, 

I have the below Product Sales data that looks like below when summarised in a table in desktop. I want to cumulative sum the sales by month 1, 2, 3 etc (refer desired result). Does anybody have a DAX solution they can suggest. 

Current State 

Date	Product A	Product B	Product C
31/10/2014		242
30/11/2014		100
31/12/2014		300
31/01/2015	1	500
28/02/2015	1	1000
31/03/2015	1	1472
30/04/2015	1	946
30/11/2016	10	66
31/12/2016	20	32
31/01/2017	1537	29	4
28/02/2017	564	31	29
31/03/2017	748	32	204
30/04/2017	475	30	354
31/05/2017	40	20	429
30/06/2017	751	19	454
31/07/2017	697	15	885
31/08/2017	738	25	1325
30/09/2017	1237	20	419

Desired Result

Date	Product A	Product B	Product C
Month 1	1	242	4
Month 2	2	342	33
Month 3	3	642	237
Month 4	4	1142	591
Month 5	14	2142	1020
Month 6	34	3614	1474
Month 7	1571	4560	2359
Month 8	2135	4626	3684
Month 9	2883	4658	4103
Month 10	3358	4687	4103
Month 11	3398	4718	4103
Month 12	4149	4750	4103
Month 13	4846	4780	4103
Month 14	5584	4800	4103
Month 15	6821	4819	4103
Month 16	6821	4834	4103
Month 17	6821	4859	4103
Month 18	6821	4879	4103

[Cookistador · Accepted solution]

Hi @hemann 

Please find another workaround which works in Power Query

All the steps can be checked

If you need more help, do not hesistate to ask for some support

This is the final result I get:

[hemann]

Thanks some of the power query logic was also useful 

[ryan_mayu]

@hemann 

you can do the data transform in PQ then use DAX to get the output. 

pls see the attachment below

[rajendraongole1]

Hi @hemann  - please find the attached pbix file. check the output as expected. 

Hope this helps.