Forum Discussion
Formula Help
Hi There ;
i need your kind help to create a measure , i tried to explain what i need ;
i have two table as below , one of them "purchasing"and the other one "inbound " , as you see i have "A "material 100 pcs which one is planned to delivery on 10.05.2020.But that goods not delivered on time , some of them early , some of them lately delivered , i need to calculate how many pcs of this order delivered on time or before according to planned date .For below example i need to find "60" pcs because last 40 pcs party delivered later then planned delivery date.So how can i find that "60 pcs " qty.
Thanks in advance
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!
6 Replies
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!
i used your formula , for filter i used order number , but that formula gave me only days and seems like as below
i just wanted to find quantitites , but the new column gaves below days just , minus and positive numbers and same , i think somthing wrong , maybe i could not tell what i wanted
dear amitchandak
i just only need to calculate and find " 60 " pcs , maybe with a formula a quick measure enough for it ? system will only calculate how many pcs real delivered based on planned delivery date and before for delivery date together.
