Forum Discussion
data between different years
Without seeing the structure of the data it would be hard to be sure.
My guess is the cell 2024(c), Week -2 has two filters that clash on it.
I assume Calendar[Week] is a column in your calendar table.
This joins via Calendar[Date] to your DataTable[Date].
When you filter the Calendar[Week] = -2 and Calendar[Year] = 2024 you are removing the 2023 data.
Does that sound correct?
If so you will need tweak your measure to change the Calendar[Year] filter.
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-KUAnd how to do relative week numbers:
https://www.youtube.com/watch?v=INaRk1CbqmgFinally 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!
