how convert dates into

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Power BI training and help » How to convert dates into financial years | Forum

How to convert dates into financial years | Forum

resolvedResolved · Medium Priority · Version 365

How to convert dates into financial years

Hi Jens,

I need to create a column converting dates into financial years in Power BI, please could you guide me on this?

Many thanks for your help.

RE: How to convert dates into financial years

Hi Teresa,

Thank you for the forum question.

The best solution is to have a financial years column in the Date table and use this financial years column in visuals where your numbers need to be shown by financial years.

If your financial years starts 1 April

financial years = YEAR(EDATE([Dates],9))

[Dates] is the column header in which you have the dates.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector


Training courses


Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


Power BI tip:

Explore Power BI Templates

Take advantage of Power BI templates to streamline report creation. Templates allow you to reuse custom layouts, themes, and configurations across multiple reports. Create templates for consistent branding or industry-specific reporting standards, saving time and maintaining a cohesive look across your organization's reports.

View all Power BI hints and tips

Server loaded in 0.07 secs.