Data Type Round up issue

[NEOM]

Hi,

Please find the below, while converting  the Decimal to whole number - sometimes round up is working and sometimes round down .

Example- For  62.5 and 61.5 showing same value.

If 0.5 come then it needs to Round up like highlighted in red color.

Result , i need like below in Query editor itself.

Thanks,

@amitchandak  @Greg_Deckler 

[Endiii]

In DAX you can use "ROUNDUP" and "ROUNDDOWN" formulas.
In PowerQuery there is function called "Number.RoundUp" and "Number.RoundDown" where you can decide which way you want to go. 

[amitchandak]

@NEOM , Are you using Number.RoundUp?

https://www.youtube.com/watch?v=_bP2GNiMIwM