Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
sportyarod
Regular Visitor

How to change fiscal year coding

I have taken over a file that already had a default calendar table.  My company's fiscal year starts on 4/1 each year and am looking to make adjustments to the calendar table to reflect this.  Right now coding is 

Fiscal Year",if(_startOfFiscalYear=1,YEAR([Date]),YEAR([Date])+ QUOTIENT(MONTH([Date])+ (13-_startOfFiscalYear),13))
 
How would I update this to start the FY in April and how can I change to have the data show as FY159 instead of 2024?
1 ACCEPTED SOLUTION
MasonMA
Impactful Individual
Impactful Individual

Hi @sportyarod 

 

If your fiscal year starts in April, then i suppose _startOfFiscalYear should equal 4 . but I'd suggest you just use below measure,

FiscalYearNum = 
YEAR([Date]) + IF(MONTH([Date]) < 4, -1, 0)

to continue to get the offset Fiscal year, use below measure.

FiscalYear = "FY" & FORMAT([FiscalYearNum] - 1865, "000")

 

Thanks 

Mason

View solution in original post

3 REPLIES 3
v-mdharahman
Community Support
Community Support

Hi @sportyarod,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you want to make changes in the calender table. As @techies and @MasonMA both have responded to your query, kindly go through the response and check if it solves your issue.

 

I would also take a moment to thank @techies and @MasonMA, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

 

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

techies
Super User
Super User

Hi @sportyarod please try this

 

Fiscal Year =
VAR FiscalStartMonth = 4
VAR FiscalYearEnd = IF(
MONTH('date'[Date]) >= FiscalStartMonth,
YEAR('date'[Date]) + 1,
YEAR('date'[Date])
)
RETURN
"F" & (FiscalYearEnd - 1865)

― Power BI | Microsoft Fabric | PL-300 | DP-600 | Blog: medium.com/@cseprs_54978
MasonMA
Impactful Individual
Impactful Individual

Hi @sportyarod 

 

If your fiscal year starts in April, then i suppose _startOfFiscalYear should equal 4 . but I'd suggest you just use below measure,

FiscalYearNum = 
YEAR([Date]) + IF(MONTH([Date]) < 4, -1, 0)

to continue to get the offset Fiscal year, use below measure.

FiscalYear = "FY" & FORMAT([FiscalYearNum] - 1865, "000")

 

Thanks 

Mason

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.