Forum Discussion

funklordofusa's avatar
funklordofusa
Icon for Helper I rankHelper I
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...
  • OwenAuger's avatar
    OwenAuger
    5 years ago

    Hi funklordofusa 

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

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

     

    Regards,

    Owen

     

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
5 years ago

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
    Icon for Helper I rankHelper I
    5 years ago

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

    Thanks!