cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
praveenkumarv Regular Visitor
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
Community Support Team

Re: DAX for Last Year End (Fiscal Year)

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:

15.png16.png

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
Super User

Re: DAX for Last Year End (Fiscal Year)

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: DAX for Last Year End (Fiscal Year)

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:

15.png16.png

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

Re: DAX for Last Year End (Fiscal Year)

Thank you very much for your response. 

 

Praveen

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

sphillips22 Frequent Visitor
Frequent Visitor

Re: DAX for Last Year End (Fiscal Year)

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