Create Fiscal Calendar - Saturday Fiscal Week Start Date

[Gazsim44]

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

[v-lili6-msft]

hi @Gazsim44 

You could use "16" as a return_type for WEEKNUM that it will return Saturday as starting.

https://dax.guide/weeknum/

Regards,

Lin

[Gazsim44]

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]

hi @Gazsim44 

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

Regards,

Lin