Forum Discussion
Filter dates as from previous ISO week (also valid when year change)
2 Comments
1 - Your date dimension only goes up to the current date so showing future records would be tough. Try extending it to the end of the current year or some other future date.
2 - Since you already have [CurWeekOffset], the following column should work for you.
Display = 'Calendar'[CurWeekOffset] >= -1I hope I understood you correctly.
Super UserAnonymous
Updated the DAX.
pls see the attachment to see if this works for you
ryan_mayu The table is showing all values from beginning of 2022 to end of 2023. Instead, it should only show the expected results as in my previous post.
I have uploaded a new PBIX file with a calendar and i added the ISOYearWeekNum column to it. I also imported the original table. Is it possible to filter the Date column and get the expected results (without any additional rows)?
Download link from my Google Drive: https://drive.google.com/file/d/1C9anYhragY_6Z8ArHU7c9mxwDkWBn_ku/view?usp=sharing
Expected results:
grantsambornSolution Sage
2 Comments
1 - Your date dimension only goes up to the current date so showing future records would be tough. Try extending it to the end of the current year or some other future date.
2 - Since you already have [CurWeekOffset], the following column should work for you.
Display = 'Calendar'[CurWeekOffset] >= -1I hope I understood you correctly.