Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to Solution.
You should be able to use the CEILING function for this purpose:
CEILING ( [forecasted sales units], [minimum order quantity] )
Regards,
Owen
You should be able to use the CEILING function for this purpose:
CEILING ( [forecasted sales units], [minimum order quantity] )
Regards,
Owen
Perfect, Owen. This is exactly the dax I was looking for.
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |