offset week number

[Anonymous]

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.

I want the week number to calculate according to this fiscal year.  

Thanks in advance!   

[Anonymous]

Hi @Anonymous ,

You can create a calculated column as below:

Fiscal week =
VAR _startmonth = 11
VAR _weekstarton = 7
RETURN
    "Week "
        & INT (
             (
                'Calendar'[Date]
                    - WEEKDAY ( 'Calendar'[Date] - _weekstarton )
                    - DATE ( YEAR ( 'Calendar'[Date] )
                        - ( MONTH ( 'Calendar'[Date] ) < _startmonth ), _startmonth, 1 )
            ) / 7
        ) + 2

If the above method is not working for you, please provide your desired result and related calculation logic. Thank  you.

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

[negi007]

@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)

[amitchandak]

@Anonymous , Please watch my video on the same.

https://youtu.be/euIC0dgGTNM

And attached file after signature

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[themistoklis]

@Anonymous 

You can check the following links:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Fiscal-Calendar-and-week-number-starting-from-April/td-p/869775

https://www.goodly.co.in/calculate-fiscal-week-in-power-bi/

Amend it where necessary