Forum Discussion
roundup
Hi, For each row i have a column dat I want to roundup ROUNDUP[QTY];0) ID | Vendor | Qty | Roundup
1 | A | 0,3 | 1
2 | B | 1,6 | 2
3 | A | 1,2 | 2
Now i want the the ...
Hey,
you have to adjust your Measure somewhat, but without knowing your formual it's also a little guesswork, if you want to round first, you have to use a tableiterator that calculates an expression on the row level and finally creates the sum
CALCULATE(
SUMX('yourtable'[customer], ROUNDUP('yourtable'[qty]'))
)Hope this helps
Hey,
you have to adjust your Measure somewhat, but without knowing your formual it's also a little guesswork, if you want to round first, you have to use a tableiterator that calculates an expression on the row level and finally creates the sum
CALCULATE(
SUMX('yourtable'[customer], ROUNDUP('yourtable'[qty]'))
)
Hope this helps
Thanks, this is the solution