cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

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

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...

1 ACCEPTED SOLUTION
Resident Rockstar

@PBNewbie - try

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!

4 REPLIES 4
Regular Visitor

Thank you!!

Resident Rockstar

@PBNewbie - maybe this one 🥸

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!

Resident Rockstar

@PBNewbie - try

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!

Resident Rockstar

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

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors