Forum Discussion
product
I have a column of product versions (example: 2.3.5 and 2.3.4) I need to be able to query that column and return a true/false. The true's need to be 2.3.5 and the false's 2.3.4. I need this to be...
I need to have a solution that doens't require updating a table everytime a new version comes out.
example: (I need to be able to use DAX to only report the non highest version. ex. 3.4.9.8 and 3.4.9.1)
Version:
3.5.6.7
3.5.6.7
3.4.9.8
3.4.9.1
Nathaniel_C
Community Champion
Community Champion
In Power Query, create second column, making sure that the ver is txt, use the find and replace. "." and leave replace with blank.
Then you should be able to use MAX() Once this is in your query you won't have to change when new version comes out.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel