Formula Help

[erhan_79]

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 

[amitchandak]

@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

[parry2k · Accepted solution]

@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]

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 ? 

[parry2k]

@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!

[erhan_79]

@amitchandak  

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 

[erhan_79]

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.