Forum Discussion
Formula Help
erhan_79 this should be pretty straight forward, see sample attached, I created two table order and order delivered and add delivery qty into two different buckets, you can make the logic change as your model.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
erhan_79 this should be pretty straight forward, see sample attached, I created two table order and order delivered and add delivery qty into two different buckets, you can make the logic change as your model.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
great parry2k ;
it is working and i got what i need , just one more question pls ;
i would like to divide " total order quantity" / total " on or before " qty .
which meausure can i use ?
erhan_79 should be easy, as a measure like this
Measure = DIVIDE( SUM ( Order[Planned Qty] ), SUM ( 'Order Delivered'[Qty] ) )Not sure what you are trying to achieve but you can change the above measure as per your requirement.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!