Help to customise rounding numbers

[Anonymous]

Good afternoon, 

Could you please help me with this one, I'm trying to round up numbers, but I need that if they are greater than %.8 then go to the closest whole number and when %.7 then decreasing to the closest whole number:

14.74 = 14

14.80 = 15

Is there a Dax formula that can help me with this? 

Thank you so much! 

[mjantune · Accepted solution]

You could do this

Uneven Round= IF(X - TRUNC(X) >=0.8 , ROUNDUP(X ,0) , ROUNDDOWN( X , 0 ) )

With X being the column you want to round unevenly. 

[Anonymous]

It worked perfectly!!! Thank you so much!!