Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.