Cumulative Values using Power Query and having a Date Restriction

[themistoklis]

I have the following table and i would like to caclulate running totals using Power Query.

ID	Value	Date	Max Date
A31	2	21/01/2018	31/10/2018
A31	3	10/02/2018	31/10/2018
A31	6	15/03/2018	31/10/2018
A32	1	10/01/2018	31/12/2018
A32	9	14/02/2018	31/12/2018
A32	6	26/03/2018	31/12/2018

I want the running total to run up to the Date specfified by the Max Date field.

The output table based on the above data will look like this. I know how to do this on DAX but I want this the same output using Power Query:

Month	ID	Cumulative Values
Jan-18	A31	2
Feb-18	A31	5
Mar-18	A31	11
Apr-18	A31	11
May-18	A31	11
Jun-18	A31	11
Jul-18	A31	11
Aug-18	A31	11
Sep-18	A31	11
Oct-18	A31	11
Nov-18	A31	0
Dec-18	A31	0
Jan-18	A32	1
Feb-18	A32	10
Mar-18	A32	16
Apr-18	A32	16
May-18	A32	16
Jun-18	A32	16
Jul-18	A32	16
Aug-18	A32	16
Sep-18	A32	16
Oct-18	A32	16
Nov-18	A32	16
Dec-18	A32	16

[Aron_Moore]

https://www.excelguru.ca/blog/2015/03/31/create-running-totals-in-power-query/