Need to create column for fiscal year that is different from calendar year

[PBNewbie]

Hi all,

I have a table 'Calendar' with the columns

[Date]      [Fiscal Year]

Our fiscal year is July 1 to June 30.  I use the following in Column Tools to create the Fiscal Year fields:

1.  Fiscal Year =

2.  CEILING(

3.      YEAR(EDATE('Calendar'[Date],-6)),

 4.      2)

This starts out correct.  An example of the output is:

           [Date}                     [Fiscal Year]

7/1/2011 12:00:00 AM           2012

7/2/2011 12:00:00 AM           2012

However, this stays Fiscal year 2012 through June 30, 2013 (when it should be Fiscal Year 2013, then it jumps two years to Fiscal Year 2014 on July 1, 2013 (which is correct).  

I am getting 24 months of the same Fiscal Year, then it jumps two years, so the first 12 months are correct, and the next twelve months are not. And this repeats over and over.  I am sure this is easy, but my head hurts...

[PBNewbie]

Thank you!!

[ChrisMendoza]

@PBNewbie - maybe this one 🥸

[ChrisMendoza · Accepted solution]

@PBNewbie - try

[ChrisMendoza]

oh geez, nevermind don't do that at all 😬