Forum Discussion

Gazsim44's avatar
Gazsim44
Helper III
6 years ago

Create Fiscal Calendar - Saturday Fiscal Week Start Date

Hi All, 

 

I have a customer for whom I am trying to set up their fiscal calendar in Power BI. Whilst I can succeed in getting Quarter's and Week's to start succesfully this is only from the current Calendar Week (WEEKNUM) which commences on a Monday.

 

How could I succesfully replicate the calendar per attached with the fiscal weeks and quarters starting on a Saturday each week / month?

 

Attached is a copy of the said calendar.

Many thanks, 

Gaz

Need Help
Tips and Tricks
Tutorial Requests

3 Replies

    • Gazsim44's avatar
      Gazsim44
      Helper III
      6 years ago

      Many thanks Lin. 

       

      How about for a Quarter to also commence on a Saturday - currently I am using the below but again this just follows the month rather than starting on a specific date / day;

       

      "Fiscal QTR", "Q"
      & CEILING ( MONTH ( EDATE ( [Date], -1 ) ), 3 ) / 3,

       

      Thanks

      Gaz

       

       

      • v-lili6-msft's avatar
        v-lili6-msft
        Community Support
        6 years ago

        hi Gazsim44 

        If so, you need to write a Multiple IF conditional formula to custom it.

         

        Regards,

        Lin