Forum Discussion
New Measures - Weekly Current Year, Weekly Last Year, YTD Weekly Current and YTD Weekly Last Year
Super UserAnonymous there are tons of posts on time intelligence, did you searched and tried?
Here is a link to few:
https://www.red-gate.com/simple-talk/sql/bi/creating-time-intelligence-functions-in-dax/
I would 💖 Kudos 🙂 if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
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
Anonymous 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