"Sort by" based on condition

[jack555]

Would like to sort the count column based on the date column. desired sorting as in Sort 1 or Sort 2. I tried sorting by date and adding index. however since it runs above million records, not a best way to do it.

Montha and date column combination sort is the ideal, however i can live with date only sorting index without affecting the performance. Please advice how to do this? either in DAX or power query.  I need this to sort a visual since "count" column values affecting the sort funciton.

I am a beginner, please guide accordingly. 

ID	Type	Item	Date	Count	Sort 1	Sort 2
1	Month	Ball	01/01/2022	55	2	8
2	Month	Bat	01/01/2022	72	3	9
3	Month	Glove	01/01/2022	30	1	2
4	Month	Ball	23/02/2022	15	4	11
5	Month	Hat	27/04/2022	80	5	15
6	Quarter	Ball	01/01/2022	33	1	4
7	Quarter	Bat	01/01/2022	40	3	6
8	Quarter	Stick	01/01/2022	21	2	1
9	Quarter	Boot	23/02/2022	70	4	12
10	Quarter	Hat	27/04/2022	59	5	14
11	Year	Boot	01/01/2022	31	1	3
12	Year	Bat	01/01/2022	48	3	7
13	Year	Glove	01/01/2022	37	2	5
14	Year	Bag	23/02/2022	10	4	10
15	Year	Hat	27/04/2022	15	5	13

[jgeddes]

You can try the following calculated column

Rank =

var _type =

'Table (6)'[Type]

Return

RANKX(

    FILTER(

        ALL('Table (6)'),

        'Table (6)'[Type] = _type

    ),

    [Date]&[Count],,

    ASC

)

Replace 'Table (6)' with your table name.

[jack555]

Thanks. I tried, below error.

column names are little different.