Hi Neds So I am using PowerBI, and I have defined my current fiscal year as

CY = 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.