MROUND

funklordofusa — Mon, 10 May 2021 12:49:19 GMT

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,

Re: MROUND

OwenAuger — Mon, 10 May 2021 22:19:07 GMT

Hi funklordofusa

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

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

Regards,

Owen

Re: MROUND

funklordofusa — Mon, 10 May 2021 22:45:47 GMT

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

Thanks!

topic MROUND in DAX Commands and Tips

MROUND

Re: MROUND

Re: MROUND