Forum Discussion
Total Last Fiscal Year Mesure
Hi all, Big Respect to Everybody. This is another question about Calendar/Date DAX Measures. I work with fiscal years starting from the 1st of April. So, if it is 01 April 2012 - it is first...
Hi,
Try this measure
=CALCULATE([Revenue],DATESBETWEEN('Calendar'[CDate],DATE(YEAR(MAX('Calendar'[CDate]))-1,4,1),DATE(YEAR(MAX('Calendar'[CDate])),3,31)))Hope this helps.
Hi Asnish,
You are right, that is the value I want to get.
but I can not use it, because the only way I could figure it out:
Revenue Last Full Year = CALCULATE ( [Revenue LFYTD];'Calendar'[CDate]=DATE(2012;3;31))
- I hard coded the fyear.
So, when the fiscal year changes (slicers or just year passes), this value remains the same unlike other measures, that switch automatically.
I do not know how to make measure for full last fiscal year, so it could work by itself, that is what I am asking.
Thank You.
Ashish_Mathur
Super User
Super UserHi,
Try this measure
=CALCULATE([Revenue],DATESBETWEEN('Calendar'[CDate],DATE(YEAR(MAX('Calendar'[CDate]))-1,4,1),DATE(YEAR(MAX('Calendar'[CDate])),3,31)))
Hope this helps.
Yes, that is exactly what I needed!
Thank You very much!
- Ashish_Mathur
You are welcome.