DAX for Last Year End (Fiscal Year)

[Anonymous]

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 

[v-lili6-msft · Accepted solution]

Hi@ praveenkumarv

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

[Carol_W]

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]

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

[Anonymous]

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

Praveen. 

[Greg_Deckler]

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

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490. Sample data would help.

[Anonymous]

Thank you very much for your response. 

Praveen