Forum Discussion
offset week number
Hi All, Hope you are doing well! I need your advice on how to offset the week number. The FY starts on 1 Nov and ends on 31 Oct. Eg - FY2021 will start from 1st Nov 2020 and ends on 31st Oct 2021...
Anonymous there is a workaround for this. you can create a measure like below. I think it will be able to help you.
Week = if('date'[Date].[MonthNo]>=11,WEEKNUM('date'[Date].[Date])-44,WEEKNUM('date'[Date].[Date])+8)