I am trying to sort the week and month column below (Week Ending Date)according to FY as currently, months are in alphabetical order.

YearWeek ReportDate              Work order Week Ending Date FinancialYrSort
202135   22/08/2022 12:00:00 AM  WO7094852  28/08/2022       2
202202   3/01/2022  12:00:00 AM  WO7465604  9/01/2022        1
202201   27/12/2021  12:00:00 AM WO7690126  2/01/2022        6
202153   26/12/2022  12:00:00 AM WO7467312  1/01/2023        6
202130   18/07/2022  12:00:00 AM WO6947586  24/07/2022       1

I've created the Financial Yr Sort column to be used for sorting -

Financial Yr Sort = If(MONTH('22a Planned Maintenance Efficiency'[reportDate]) > 6, MONTH('22a Planned Maintenance Efficiency'[Week Ending Date]) - 6, MONTH('22a Planned Maintenance Efficiency'[reportDate] + 6))

This generates July months from No 1 and goes on. When I try to sort Weekending dates by Financial year an error message pops up. Please see the 2nd picture.

Can someone help me to sort this out? Please note I want show the line graph by week. Please refer to the 3rd picture.