Year to date measure column on table with multiple rows with the same date

(0) Share

Report

Posted on by Bozintheuk1

Hi Community

Any idea how to make a YTD/cumulative column in Power Query that SUMS the sales column if the date is >= the start date of the year and <= the Date of the row. My table has three rows (category) per date.

Date	Category	Sales	YTD
01-Apr-2021	1	50	50
01-Apr-2021	2	100	100
01-Apr-2021	3	275	275

07-Apr-2021	1	25	75
07-Apr-2021	2	50	150
07-Apr-2021	3	150	425

08-Apr-2021	1	50	125
08-Apr-2021	2	100	250
08-Apr-2021	3	275	700

09-Apr-2021	1	25	150
09-Apr-2021	2	50	300
09-Apr-2021	3	150	850

12-Apr-2021	1	50	200
12-Apr-2021	2	100	400
12-Apr-2021	3	275	1,125

13-Apr-2021	1	25	225
13-Apr-2021	2	50	450
13-Apr-2021	3	150	1,275

14-Apr-2021	1	50	275
14-Apr-2021	2	100	550
14-Apr-2021	3	275	1,550

15-Apr-2021	1	25	300
15-Apr-2021	2	50	600
15-Apr-2021	3	150	1,700

Check
YTD	1	300
YTD	2	600
YTD	3	1,700