Hi Neds So I am using PowerBI, and I have defined ...
# general
b
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.