Forum Discussion
data between different years
Hi all, i have this table in excel about the turnover of a store, in excel the problem is that when i am in the weeks across 2 years (see the pic) i don't see the data of the year before, for exampl...
the image is still from excel.
I want to replicate it in power bi correcting tha wrong situation, the problem with our data structure comes from our commercial calendar of 52 weeks, it can happen that week 52 can be split between 2 years, so the first days of the new year are week 0 but still have to be sum to the last days of previous year to have the complete week 52
Ahh Avi Singh did some superb videos on how to do offset week calendars:
https://www.youtube.com/watch?v=NKr2TizM-KU
And how to do relative week numbers:
https://www.youtube.com/watch?v=INaRk1Cbqmg
Finally he did a video all about his free calendar table:
https://www.youtube.com/watch?v=CJ2y6v4mQZk
Give them a skim and see if it does what you need!