I have a code below and each May is a new fiscal year.
Lets assume: we are in FY25 June ->I need to filter the table below for FY25 May.
: if we were in FY25 May ->I need to filter the table below for FY24 April.
How can i get around with this ? many thanks in advance.
Amount QTD =
CALCULATE(
[measure],
DATESQTD('Calendar'[Date])
)
Amount YTD =
CALCULATE(
[measure],
DATESYTD('Calendar'[Date], "4-30")
)
Expected Table for FY25 June