Forum Discussion
Post PatronWorking out Financial Week Number 2019/20 and beyond
Hi - I wonder if anyone can help. I have created a column to work out financial week number with week 1 starting in April. This has worked fine. However can anyone help me as to why Financial week number is Apr 2019 AND March 2020 for the financial year 2019/20?
I used this calculation -
3 Replies
- amitchandak
Super User
lennox25 , Try like
FY Week = QUOTIENT(DATEDIFF(Minx(FILTER('Date',[FY Start Date]=EARLIER([FY Start Date])),'Date'[Start of Week]),[Date],DAY),7)+1
or go to a sunday/monday of FY Start date
FY Week Start = [FY Start Date] - weekday([FY Start Date],2) +1 // Monday
FY Week = QUOTIENT(DATEDIFF(Minx(FILTER('Date',[FY Week Start ]=EARLIER([FY Week Start ])),'Date'[Start of Week]),[Date],DAY),7)+1
Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441
https://medium.com/chandakamit/cheat-sheet-calendar-of-any-standard-month-just-one-variable-apart-5ee47de6a208
lennox25Hi amitchandak Do you have a power BI example? I just cant get it to work 🙂
- lennox25
Hi amitchandak - Scrub that -Ive got it to work - but can the formula you provided be tweaked so I have 52 weeks? TIA
