Week number for Fiscal Year

[jackypatel]

My Fiscal Year is Start from 25th March & end on 24th March. For this i need Week Number. (week start from Monday)

For Example - 25th march(Saturday) & 26th March(sunday) --- So this is My "WEEK 1" &

                       27th March(Monday) to 2nd April(Sunday)  --- So this is my "WEEK 2"  

     .............. till 24th April(Monday) only --- "WEEK 6"  For April Month.

It will continue for Next month also

This week Duration will be change every month & year.

If you need More details. plz revert me. 

[lbendlin]

Use an external reference table (Excel file on a SharePoint for example).  There is no point in trying to do this in Power Query or DAX.