Assuming that 'transaction_date' in your example is the date in which you need to find the fiscal week of, its a matter of determining the difference between 4/1 and that...

I'm not quite sure whether you're asking how to calculate the fiscal week or year.  Regarding your supplied SQL code, if DATEPART isn't working, try using MONTH(transaction_date) to get your month...