Custom Quarter Date Column in Chronological order

[sa34techer]

I created a calendarauto(6) fiscal dax date table with a custom column --> FY Q YYYY = IF(MONTH('FY Calender'[Date])>6,"FY "&FORMAT(EDATE('FY Calender'[Date], -6),"\QQ")&" "&YEAR('FY Calender'[Date])&"-"&YEAR('FY Calender'[Date])+1,"FY "&FORMAT(EDATE('FY Calender'[Date], -6),"\QQ")&" "&YEAR('FY Calender'[Date])-1&"-"&YEAR('FY Calender'[Date])).

The FY Q YYYY column is sorting like this:

How to sort the FY Q YYYY fiscal chronological order like this below?

FY Q2 2024-2025

FY Q1 2024-2025

FY Q4 2023-2024

FY Q3 2023-2024

FY Q2 2023-2024
FY Q1 2023-2024

FY Q4 2022-2023

FY Q3 2022-2023

[lbendlin · Accepted solution]

add this column to your calendar table

QNo = FORMAT([Date],"yyyyq")

Then sort your FY Q YYYY column by that column.