Forum Discussion

billyrich83's avatar
billyrich83
Frequent Visitor
4 years ago

Help required

Hi all I have the below calculation for fiscal week numbers, however it start the fiscal canlendar to start on the 1st April each year and I need it to start on the 1st Monday in April each year.   ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

billyrich83 , Try these new columns

 

Start Of year = if(month([Date]) <4, date(year([Date])-1,4,1), date(year([Date])-1,4,1))


Start of Week = 'Date'[Date]+-1*WEEKDAY('Date'[Date]

 

FY Start of Week = minx(filter('Date', [Start of Week] >= [Start Of year]), [Start of Week])

 

FY Week No = quotient(datediff([FY Start of Week], [Date], day),7) +1