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...
Those are informative posts.
My question is more on what to do with Weekly measures. The YTD, QTD or MTD work fine for me. Given WTD or week to date functions are not available in Power BI, I need further guidence.
Thank you
Jen
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