Financial Week Calculation

[PWD]

Good morning we are trying to put together a report that shows the Financial Week of each appointment date. I don't know if our (yet to be built) Universe will have an appropriate table so, if only for the moment, I was thinking of creating a calculated variable directly in the BO report.

In the United Kingdom, the financial year runs from 1 April to 31 March.....

So I have started with:

DaysBetween =DaysBetween(ToDate("01/04/2015";"");[Appointment Date])

I was then thinking that I'd have to create another variable that has 51 nested If statements. This seems very tedious!

Any thoughts please?

Many thanks,
D€$