Forum Discussion
Solved
Sorting mixed data type in power bi
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?
Use this
= Number.From(Text.Select([Period Number],{"0".."9"}))
3 Replies
In a custom column, put following formula and then sort on this custom column
= Number.From(Text.Split([Period Number]," "){1})
OK thanks and what if in some situations there is an asterisk? It appears this formula wont work then
Use this
= Number.From(Text.Select([Period Number],{"0".."9"}))
