Forum Discussion
dshah12
Helper II
Helper IIFiscal Year from Date
I am getting data using the direct query and wanted to create a fiscal year range from date but it does not work from below DAX it gives 2022-2023.0 and similar redundant Fiscal Year = VAR...
lbendlin
Super User
Super UserThis should work, but can be refactored
Fiscal Year =
VAR CurrentYear = YEAR(cmhc_drawscheduleitem[cmhc_date])
RETURN
IF(
MONTH(cmhc_drawscheduleitem[cmhc_date]) >= 4,
CurrentYear & "-" & (CurrentYear+1),
(CurrentYear-1) & "-" & CurrentYear
)