Rounding up the the nearest .5

[TomerIwanir1]

Hi

I have a numbers column, I want to round up the numbers to the nearest 0.5

for example:

1.2 ----> 1.5

1.9---->2

0.6--->1

0.4---> 0.5

tried all the round function W/O any success,

thanks

[Anonymous · Accepted solution]

Hi @TomerIwanir1 ,

I create a table as you mentioned.

Then I think you can use CEILING function and here is the document: CEILING function (DAX) - DAX | Microsoft Learn

So here is a new calculated column.

Column = CEILING('Table'[Number] * 2, 1) / 2

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SachinNandanwar]

You could try one of these functions

https://www.sqlbi.com/tv/floor-mround-ceiling-iso-ceiling-dax-guide