Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
87 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
96 | |
80 | |
72 |