Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

UK Fiscal Year Calendar table

Hi

I have managed to create a calender table which starts from 1st April and it recrods it as Q1/YYYY but I need Q1/YYYY to start from 5th April YYYY.

Any help will be much appriciated.

Tips and Tricks

Vijay_A_Verma
4 years ago
Formula for Fiscal Quarter
FQ = "Q"&MOD(2+ROUNDUP(MONTH([Date]-3)/3,0),4)+1
Formula for Fiscal Year
FY = YEAR([Date])-(MONTH([Date]-3)<4)

3 Replies

tom480
Resolver I
4 years ago
Hi Anonymous ,

You could use something like this when building your date table. If this works for you, please mark as a solution.

Here I am getting the Julian date and then starting at one. Then it's easy to add a column and state what Quarter the date is in.

Quarter = IF( [JulianNo] < 91, "Q1",IF( [JulianNo] < 181, "Q2", IF( [JulianNo] < 271, "Q3", "Q4")))

Have a great day! Always glad to help! Tom 😀

Part of the Date Table code, to get the Julian Date
- Anonymous
  Not applicable
  4 years ago
  Thank you, but quite does not work as for the next finacial year the dates 01/04 - 05/04 come up as Q1 rather than Q4
Vijay_A_Verma
Most Valuable Professional
4 years ago
Formula for Fiscal Quarter
FQ = "Q"&MOD(2+ROUNDUP(MONTH([Date]-3)/3,0),4)+1
Formula for Fiscal Year
FY = YEAR([Date])-(MONTH([Date]-3)<4)

Related content