Fiscal Week of Year

[adstott90]

Hi all,

I’m working on a query at the moment and I want to compare the weekly revenue and customers with that of the previous year. Sounds straightforward, except that I want to compare weeks of the financial year (starts 01/04/2020) with last year. So essentially what I want the table to look like is something like this:

Week No. | FY 2020 Revenue | FY 2019 Revenue | Year on Year change |
1
2
3
4
etc.

The problem is I can’t seem to work out how to generate the week number of the financial year consistently - anyone done this previously or have any tips on where to start?

Thanks, Adam