Sorting mixed data type in power bi

[natasha519]

I have 2 columns (Period number and I added an index column). Screenshot below:

When I do sort descending, it's not recognizing Period 10 should have a value of 0. Any ideas how to fix this?

[Vijay_A_Verma]

In a custom column, put following formula and then sort on this custom column

= Number.From(Text.Split([Period Number]," "){1})

[natasha519]

OK thanks and what if in some situations there is an asterisk? It appears this formula wont work then

[Vijay_A_Verma · Accepted solution]

Use this

= Number.From(Text.Select([Period Number],{"0".."9"}))