Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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
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
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.
Thank you for replying to my question. I can use this expression in my report.
Praveen.
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.
Thank you very much for your response.
Praveen
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
90 | |
83 | |
76 | |
64 |
User | Count |
---|---|
146 | |
111 | |
109 | |
103 | |
96 |