roundup of dateiff

[djreyes]

Hi, 

Please help - how can I add roundup in this - DATEDIFF(Clean[shipmentDate],Clean[Scan Event Date],DAY)

I am getting an error when I tried to add Roundup(DATEDIFF(Clean[shipmentDate],Clean[Scan Event Date],DAY))

Thank you for your help!

[Greg_Deckler]

@djreyes Roundup(DATEDIFF(Clean[shipmentDate],Clean[Scan Event Date],DAY),0)

[djreyes]

I think I am doing something wrong, in my fields I changed from sum to average. I did add your what you said and its still showing decimal places. 

[danextian]

Hi @djreyes 

@Greg_Deckler's formula is correct but you seem to be using it the wrong way. Average of whole numbers can still return decimals unless you make the average itself roundup or down to the nearest whole number.