'Averaged' number in table not rounding

[Anonymous]

Hi, 

I have a set of data that is all rounded to the nearest 100, however when i put the data into a table and choose to average it, the number isn't rounded. 

Is there anyway to round table totals?

Thanks!

Sonia

[v-lili6-msft]

Hi,@ SoniaL

You may try to use round function to create a measure or column like below:

Column = AVERAGE(Table3[Qtu])

Column 2 = ROUND(AVERAGE(Table3[Qtu]),0)

Best Regards,

Lin