(DAX) Min and Max of a list of String values

[Anonymous]

I've done this in other systems but can't think how I would achieve this in DAX inside a measure.

I have a column of string values and i want to get the "highest"string value based on alphabetical order.  In this case my strings are Version numbers with multiple periods. (i.e. '12.1.1101.401', '12.1.7004.6500', '12.1.4100.4126'). I'm sure other cases might come up where version numbers contain Alpha characters too.

Anyone have a trick that would return the last value if ordered alphabetically from a column of Text?

[Anonymous · Accepted solution]

Solved it.  Using LASTNONBLANK('Table'[Field], 0)

This got me the correct answer.