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

Anonymous
Not applicable

DAX for Last Year End (Fiscal Year)

Dear All,

Could anyone please let me find a way to obtain the Last Year End from the current year selection. We are using Fiscal Year for our calculation. Our Fiscal year starts in JULY and ends in JUNE

For example,

Fiscal Year start is 1st July, 2016

Fiscal Year End is 30th June, 2017

We are in need of getting the Last Year End, for example,

if we select August 2016 then we need to have the result as June 2016.

since our Fiscal year spans from JULY to JUNE.

Selected Year: August 2016   means Required Last Year End: JUNE 2016

Selected Year: JUNE 2016      means Required Last Year End: JUNE 2015

We request you to kindly provide us the way to calculate this using DAX expression

Thanks and Regards,

Praveen

1 ACCEPTED SOLUTION
Community Support

You can try to use this measure asbelow:

`Measure = IF(MONTH(MAX('Date'[Date]))>6,"June " & YEAR(MAX('Date'[Date])),"June " & (YEAR(MAX('Date'[Date]))-1))`

Result:

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 REPLIES 6
Community Support

You can try to use this measure asbelow:

`Measure = IF(MONTH(MAX('Date'[Date]))>6,"June " & YEAR(MAX('Date'[Date])),"June " & (YEAR(MAX('Date'[Date]))-1))`

Result:

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

Hi there,

Great DAX to get the last year end date. Could someone please help me in getting the value of this particular year end date.

For example, I have sales data for many years, when I use Calculate and try to filter only last year end date, what the DAX will be?

Thanks heaps.

Anonymous
Not applicable

@v-lili6-msft  This is a good answer, thank you!

Anonymous
Not applicable

Thank you for replying to my question. I can use this expression in my report.

Praveen.

Super User
`Last Year End = "June " & YEAR(MAX([SelectedDate]))-1`

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Thank you very much for your response.

Praveen

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