Custom sorting weeks

[G3S]

the data set has these fields.

• ISCDate (syntax dd/mm/yyyy)
• ISCWeek (1-52)
• ISCYear (multiple years, example 2022)
• ISCYearWeek (syntax  example: 2022-44)

there's a straight table with measures by ISCWeek. (goes from wk 1-52). how can I sort this table so that current week is at the top and the rest follow? (based on today's date, need it to show week 13 at the top. week order will be 13,14,15...51,52,1,2...11,12

thank in advance

[vinieme12 · Accepted solution]

You can still sort Weeks based on the Date values

Use Sort by Expression and use expression  = Max(ISCDate )  or Min(ISCDate )

[G3S]

thank you @vinieme12 ..that worked a treat ..but since the table has a measure with a modifier it is basing the sort on that. not going in order as required. Any suggestions?

can you please also explain how the max/min is doing the sort? I can't figure out. thank you.

[vinieme12]

can you post a snapshot of the table? do mask any sensitive info

[G3S]

all are master measures in the table. the weeks are missing in the places marked with red arrow. these weeks exist in the table but further down the list.. 

sorting properties shows this message: