Butho Moyo
01/25/2024, 5:45 AMCY = Max(myCalendar["FY"])
.
My fiscal year runs from July to June of the preceding year. In the table myCalendar, FY is defined as
FY = "FY" &
if('myCalendar'[Month_Num]<7,'myCalendar'[Year]-1 &"-"& 'myCalendar'[Year],'myCalendar'[Year] &"-"& 'myCalendar'[Year]+1)
This gives me a text output, for example,FY2023-2024
and that is exactly what I want.
However, I am trying to define a measure, LY, that gives me the last fiscal year, for example,FY2022-2023
. I tried using the sameperiodlastyear function, but it didn't work. Any ideas would be appreciated.