Forum Discussion
Solved
Creating dynamic categories using DAX
Hi everyone, I have a problem that is more mathetical infact. I would appreciate if someone helps. I have a table as shown below orderline_id order_id qty 1 ...
rashidanwar Try the alternate formula I posted:
Measure = VAR __qty = SUM('Table'[Column1]) VAR __Mod = MOD(__qty,9) RETURN IF(__Mod = 0, DIVIDE(__qty,9), TRUNC(DIVIDE(__qty,9))+1)
Greg_Deckler intelligent!
Thank you, so much.
rashidanwar Thanks! 🙂