Forum Discussion

AviBI's avatar
AviBI
Frequent Visitor
6 years ago

Fiscal Week

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 

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    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.⚡

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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