Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
Solved it. Using LASTNONBLANK('Table'[Field], 0)
This got me the correct answer.
Solved it. Using LASTNONBLANK('Table'[Field], 0)
This got me the correct answer.
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |