Forum Discussion

avidthinker's avatar
avidthinker
Frequent Visitor
1 year ago

Sorting of values

Hi, I have a spreadsheet that contains the values below.   Ver 5.29.1 5.29.1 5.29.1 8.03 8.02 8.02   The above is correctly sorted in Excel. When I create a data...
Need Help
avidthinker's avatar
avidthinker
Frequent Visitor
1 year ago

Hi Akash_Varuna,


Thanks for the tip, ideally I should have a baseline to compare to.

The data field is versions of software released, with a baseline I can do a check on x.xx (or x.x) which I know if the latest and to then filter on the latest.

The latest version baseline I do not have and I need to go on the Ver field which is tricky.

Sometimes x.x (stored as decimal) is the latest, sometimes x.xx (stored as text) is the latest.
Trying to figure out a mechanism that works in all scenarios.



 

Anonymous I am unable to arrive at a definitive suggestion to test to mark as a solution, please bear with me to see what the community suggests whilst I also pursue a solution.

Thank you

 

  • Akash_Varuna's avatar
    Akash_Varuna
    Super User
    1 year ago

    Hi avidthinker Then Can you convert all version numbers to text to standardize the format? Then, create a calculated column in Power Query to normalize the versions (padding with leading zeros like 08.03.00 for consistent sorting). Finally, sort the normalized column to identify the latest version dynamically and filter accordingly.