Forum Discussion
New Measures - Weekly Current Year, Weekly Last Year, YTD Weekly Current and YTD Weekly Last Year
Hi there, I have a transaction list. It runs on daily basis. I have it summarized by week ending #. Something like this: Ticket Number | Date | Amount | Week Ending # It could have mult...
parry2k
Super User
Super UserAnonymous there are tons of resources on WTD as well, here is a link to one
Thank. I think that I asked the question the wrong way.
| Tonnes Last Year | Tonnes This Year | Tonnes Last Year Cumulative | Tonnes This Year Cumulative | |
| Week 1 | 250 | 238 | 250 | 238 |
| Week 2 | 300 | 526 | 550 | 764 |
| Week 3 | 125 | 114 | 675 | 878 |
| Week 4 | 382 | 538 | 1057 | 1416 |
| Week 5 | 405 | 410 | 1462 | 1826 |
| Week 6 | 508 | 235 | 1970 | 2061 |
| Week 7 | 137 | 233 | 2107 | 2294 |
I am trying to create measure for the cumulative columes.
I have following ...
Tonnes 2020 cumulative = TotalYTD(sum('data table'[Tonnes]),'data table'[date],if('data table'[Year]=2020,2020,0))
It's returning weekly numbers by the week. Not YTD culmulative.
Appreciate your help as always.
Jen