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 ,
There should be order no too. But you can have a new column like this in inbound
new column = datediff(inbound[receipt Date],maxx(filter(purchasing, purchasing[material] =inbound[material]),purchasing[planned deilvery date]) ,day)
The filter can have an order number also id need may need to have cumulative total
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!
