You’re offline. This is a read only version of the page.
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 |
Share
Report
All responses (
Answers (
426
