MROUND

[funklordofusa]

I'm using MROUND to assist in preparing a purchase forecast to give to a supplier based upon our sales forecast and their minimum order quantity.

The basic dax for my column is: 

     IF( Column A = "parameter X", MROUND( [forecasted sales units], [minimum order quantity] ) )

However, there is a remark for MROUND: MROUND rounds up, away from zero, if the remainder of dividing number by the specified multiple is greater than or equal to half the value of multiple.

In my case, let's say the forecasted sales units = 4 per month and the minimum order quantity = 9.  The dax is rounding down based upon the remark but I would prefer it to always round up to the multiple.

Is it possible to basically combine MROUND (for the multiple) and ROUNDUP?

Thanks,

[OwenAuger · Accepted solution]

Hi @funklordofusa 

You should be able to use the CEILING function for this purpose:

CEILING ( [forecasted sales units], [minimum order quantity] )

Regards,

Owen

[funklordofusa]

Perfect, Owen.  This is exactly the dax I was looking for.

Thanks!