Forum Discussion

MrMarshall's avatar
MrMarshall
Helper II
7 years ago
Solved

Creating a fiscal week column

Trying to create a Fiscal week column from WeekNum in my Calendar table. I got the WeekNum done already. Fiscal year starting on Week 40, so I am trying to create something like the one below:  I w...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    MrMarshall - Not sure what went wrong, take a look at this PBIX file attached. Table3.

     

    It looks like you missed the if statement.

ChandeepChhabra's avatar
ChandeepChhabra
Impactful Individual
6 years ago

I have recently written a blog post to customize the fiscal week. Please check it out here - https://www.goodly.co.in/calculate-fiscal-week-in-power-bi/

 

  • You'll have the option to customize the fiscal year start month.
  • And starting day of the week - Eg. mon, tue etc..

Just copy the DAX code and create a new column in your date table and paste it there! It should work fine!

Let me know..thanks

  • esylvestre's avatar
    esylvestre
    Regular Visitor
    6 years ago

    Defintely a more complete answer. You take care of most of the edge cases.

    Personal suggestion, I'd make sure localization can't impact results.

    In my case, I had to use a lowercase case for the first day of week (working in French) since in English use a capital letter for weekdays.

    Great work, thanks.

  • SQLSessions's avatar
    SQLSessions
    Regular Visitor
    5 years ago

    This is *exactly* what I was looking for, and my fiscal year even starts in April and my fiscal weeks on Mondays, so that was serendipitous!  Thank you so much!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Chandeep,

    Quick question is there a way to get the weeks to continously count from YOA?

     

    Attached an example.