Compare current revenue measure with last month of last fiscal year

[KC03]

Hello PBI experts,

I need help with creating a measure for last month of last fiscal year which will be compared with current month .

For instance, Our fiscal year is April to March

for May-2023 , revenue will be compared with Mar-2022. Similarly for April-2024, revenue will be compared with Mar-2023 

Let me know if you need more explaination on my request here.

Thanks

Komal

[amitchandak]

@KC03 , Try measure like

Last month last FY =
var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _min = if(month(_max) <4, Date(year(_max)-1,4,1) ,Date(year(_max),4,1) )
var _max1= _min -1
var _min1 = eomonth(_max1,-1)+1
return
calculate([net],DATESBETWEEN('Date'[Date],_min1,_max1))