Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

decimal roundoff to 1 decimal unit

hi

 

i have 35.97 is the two decimal value  2 when i keep decimal places to 1 . It is showing 36.0 instead of 35.9 . How i can correct this . I am using advance card for this

 

 

 

Need Help

1 Reply

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous ,

     

    The function ROUNDDOWN should work well in your scenario.

     

    Measure = ROUNDDOWN(SUM(Table1[Column1]),1)