Forum Discussion

jackypatel's avatar
jackypatel
Icon for Helper I rankHelper I
2 years ago

Week number for Fiscal Year

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. 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    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.