Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help to customise rounding numbers

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! 

Need Help
  • mjantune's avatar
    mjantune
    6 years ago

    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. 

2 Replies

  • mjantune's avatar
    mjantune
    Regular Visitor
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

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