Fiscal Week Calculation Starting on Sundays, I need Saturday

[Anonymous]

Hi All!

I have this dates tables which I use to gather the different fiscal periods, and year based on normal calendar dates. 

I found a formula on how to calculate the fiscal calendar week, my challenge here is that actually it is starting on sundays, not saturdays as the fiscal weeks are in this case for me actually. 

Period Date is the Normal Calendar Date.

Period Year is the Fiscal Year based on the Calendar Date. 

Here's the formula: 

Fiscal Week = IfERROR(DATEDIFF(

CALCULATE(

FIRSTDATE(Period[Date]),

FILTER(

ALL(Period),

'Period'[Period Year] = EARLIER('Period'[Period Year])

&& 'Period'[Date] <= EARLIER('Period'[Date])

)

),'Period'[Date],WEEK)+1,-1)

The result is the following:

As I said I would like for the Fiscal Week to start on saturday, not sunday.

Any help is appreciated.

Thanks in advance!

[amitchandak · Accepted solution]

@Anonymous , I have a series of Articles on the calendar

This one should help you

https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482

Other Articles in series

1. https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441

2. https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482

3. https://community.powerbi.com/t5/Community-Blog/Week-That-Resets-Yearly-Decoding-Date-and-Calendar-3-5-Power-BI/ba-p/1187502

4. https://community.powerbi.com/t5/Community-Blog/Travelling-Across-Workdays-Decoding-Date-and-Calendar-4-5-Power/ba-p/1187766

5 . https://community.powerbi.com/t5/Community-Blog/Date-as-Dateadd-Decoding-Date-and-Calendar-5-5-Power-BI-Turning/ba-p/1187827