Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Fiscal Week Calculation Starting on Sundays, I need Saturday

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!
Need Help

1 Reply