topic Re: Rounding up the the nearest .5 in DAX Commands and Tips

Rounding up the the nearest .5

Anonymous — Wed, 14 Aug 2024 10:17:02 GMT

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

SachinNandanwar — Wed, 14 Aug 2024 10:32:43 GMT

Anonymous — Thu, 15 Aug 2024 06:38:36 GMT

Hi Anonymous ,

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.