Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Rounding in table

Hi, 

 

I would like to round numbers to the closest 10 or 100 in a table in PBI desktop visualization table (not in the data). I found it possible to have no decimals, however not to round to closest 10 or 100. I am starting to suspect that it is not possible?

 

 

 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous ,

    Switch(true(),

    [measure] < 100, roundup([measure],1) ,

    roundup([measure],2)

    )