I am trying to figure out my error in the below query.
If the Date logged is greater than 7 then populate "FY" and the Year of the Date Logged.
Logged FY = IF(MONTH('Case Data'[Date Logged]<7)& "FY",YEAR('Case Data'[Date Logged])& "FY",YEAR('Case Data'[Date Logged])+1)
I would like my result to be
FY2021
FY2020
FY2019
FY - Text
2021 - Year (Date Logged)
Thank you in advance