cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
siopow Frequent Visitor
Frequent Visitor

greater than or equal to [version number- 16.0.10827.20150 ]

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! 

1 ACCEPTED SOLUTION

Accepted Solutions
siopow Frequent Visitor
Frequent Visitor

Re: greater than or equal to [version number- 16.0.10827.20150 ]

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. 

3 REPLIES 3

Re: greater than or equal to [version number- 16.0.10827.20150 ]

just delete points and compare like a whole number?

 

for example,

old-> 1601082720150

new -> 1601082720151

new > old

 

Community Support Team
Community Support Team

Re: greater than or equal to [version number- 16.0.10827.20150 ]

Hi @siopow,

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

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

Result:

1.PNG

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
siopow Frequent Visitor
Frequent Visitor

Re: greater than or equal to [version number- 16.0.10827.20150 ]

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.