I want to get prevous year week values . Without hardcoiding means
How can i achevie that
Previous year is week format & when ever the 53 week comes that data come that show not go current year 1 st week
I am not 100% sure what is the end goal of this, but it sounds like you could try using OFFSET and maybe RANK to try finding solution to this.
i want to get previous year weeks to the current year . but Whenever the the 53rd week comes thats should be stand alone . which means the 2022 53 rd shouldld not comes to 1st week of 2024 . But Offset will not work bcz of timeperiod format and don;t know about the rank
Have you tried the AddYear() function? That returns a date and then you can wrap that function within the Period() function.