Forum Discussion

funklordofusa's avatar
5 years ago
Solved

MROUND

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,

  • Hi funklordofusa 

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

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

     

    Regards,

    Owen

     

2 Replies

  • Hi funklordofusa 

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

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

     

    Regards,

    Owen

     

    • funklordofusa's avatar
      funklordofusa
      Helper I

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

      Thanks!