Forum Discussion
NEOM
3 years agoNew Member
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 t...
Endiii
3 years agoFrequent Visitor
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.