Forum Discussion
Dax function to sort by number
Dear all,
I created a table, I want below questions to be sorted by Q1-Q10, not by below order, any one can provide soem detail solution? Thank you so much.
xiumi_hou couple of suggestoin comes in mind
- add a zero in front of single digit Q1 will be Q01 and so on and it will sort out by itself
- if you still want to show Q1, Q2 with single digit, add another column with 0 padded like Q01 and sort your column with new column in modelling tab and then you will see single digit number are sorted correctly.
1 Reply
xiumi_hou couple of suggestoin comes in mind
- add a zero in front of single digit Q1 will be Q01 and so on and it will sort out by itself
- if you still want to show Q1, Q2 with single digit, add another column with 0 padded like Q01 and sort your column with new column in modelling tab and then you will see single digit number are sorted correctly.