Forum Discussion

Gazsim44's avatar
Gazsim44
Icon for Helper III rankHelper 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 curren...
Need Help
Tips and Tricks
Tutorial Requests
  • Gazsim44's avatar
    Gazsim44
    Icon for Helper III rankHelper 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
      Icon for Community Support rankCommunity Support
      6 years ago

      hi Gazsim44 

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

       

      Regards,

      Lin