Forum Discussion
Data Type Round up issue
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,
2 Replies
NEOM , Are you using Number.RoundUp?
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.
