cancel
Showing results for
Did you mean:
Regular Visitor

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

Accepted Solutions
Community Support Team

## Re: DAX for Last Year End (Fiscal Year)

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.
5 REPLIES 5
Super User

## Re: DAX for Last Year End (Fiscal Year)

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

Proud to be a Datanaut!

Community Support Team

## Re: DAX for Last Year End (Fiscal Year)

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

## Re: DAX for Last Year End (Fiscal Year)

Thank you very much for your response.

Praveen

Regular Visitor

## Re: DAX for Last Year End (Fiscal Year)

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

Praveen.

Frequent Visitor

## Re: DAX for Last Year End (Fiscal Year)

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