Forum Discussion
Rounding up the the nearest .5
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
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) / 2Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- SachinNandanwar
Impactful Individual
You could try one of these functions
https://www.sqlbi.com/tv/floor-mround-ceiling-iso-ceiling-dax-guide 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) / 2Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
