Fiscal Week

[AviBI]

Hi all

I have a calendar table where I have also managed to add a calculated column with the fiscal month, year and week etc. 

Now I need calculate measures such as Last Fiscal Week and Previous Fiscal Week etc as these will be used across a range of reports. 

Is there a way of calculating such measures where we can identify the what the Last Fiscal Week is based on current week / date?

Any ideas would be much appreciated

Thanks

@amitchandak @Greg_Deckler @mahoneypat @parry2k @Fowmy 

[amitchandak]

@AviBI , add these your calendar

Start Year = STARTOFYEAR('Date'[Date],"3/31") // Change end date as per Your FY
WeekDay = WEEKDAY([Date],2) //monday
Start of Week = [Date] -[WeekDay]+1 //monday
FY Year = YEAR('Date'[Start Year]) // use end year
FY Week = QUOTIENT(DATEDIFF(Minx(FILTER('Date',[FY Year]=EARLIER([FY Year])),'Date'[Start of Week]),[Date],DAY),7)+1

[parry2k]

@AviBI there are tons of resources online, check this video and you can take it from there.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡