DAX to organize date range

[BeginnerBI]

I am working with deliquency and I am trying to organize the alphanumeric groups

This is how looks now

0-15 days

120-150 days

59-90 days

and I am trying to sorted numerically

0-15 days

59-90 days

120-150 days

Please help 😞

[tamerj1 · Accepted solution]

Hi @BeginnerBI 

you add a calculated column:

Index =
SWITCH (

'Table'[Column],

"0-15 days", 1

"59-90 days", 2

"120-150 days", 3

)

Select [Column] go to column options then use the (sort by column) option and select [Index]