Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sorting the Numbers in Text format

HI All, I need help in sortign this issue. I have a numbers which in a text format in a string , which I want to sort in the Asc- desc. I did the sorting, but 10X comes before 2X, i want to have ...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI amitchandak ,

     

    Thanks for your reply!

     

    I had tried this option.. But still it doesn't sort.

    Attachig my file for your refernce.

     

    Thanks,

    Tejaswi

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      Anonymous is this what you are looking for?

       

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        Anonymous see attached, check logic in Power Query, you can tweak the logic on your larger dataset but this one is tested on this smaller dataset, I assume this will give you an idea and get started. Cheers!!

         

        I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!