greater than or equal to [version number- 16.0.10827.20150 ]

[Anonymous]

greater than or equal to [version number- 16.0.10827.20150 ]

is this possible? need to compare version number values with 3 decimal points.  if i treat it as a string it won't be able to do a greater than or equal to. hope that made sense! 

[Anonymous · Accepted solution]

https://community.powerbi.com/t5/Desktop/Sorting-Version-Number-with-multiple-decimal-points-formatt...

found this other post here regarding sorting version numbers, going to try using this instead. 

[v-danhe-msft]

Hi @Anonymous,

Based on my test, you could use the RIGHT function to get the last three number:

Column = RIGHT('Table1'[Version],3)

Result:

Regards,

Daniel He

[petrovnikitamai]

just delete points and compare like a whole number?

for example,

old-> 1601082720150

new -> 1601082720151

new > old