Supplier Date reilablity

[Yashh]

Hello all,

I am working on Supplier Reliablity Dashboard for Quantity and on time delivery. But I am stuck on a point with the date reliablity. 

In this sample data set we have the supplier, GR date, Scheduled date and Static Delivery date. 

• GR date is the date when the material is recivend in the Plant. 
• Scheduled Date is when it is expected in the plant.
• Static delivery Date is the date when supplier says he will deliver.

I have to calcualte the date reliablity rate in perecent for supplier.

Like if the delivery is 0 days late it is 100%

if 1 day late it is 80%

if 2 days late it is 60%

if 3 days late it is 40%

if 4 days late it is 20%

if 5 days late it is 1%

and more then 5 days it is also 1%

And if the delivery is early then it should show 100%.

@Ahmedx  Please help

[Ahmedx]

I do not understand. you explain here what percentage will be, and why?

[Yashh]

Hello @Ahmedx 

I want to do supplier rating on the delivery date. So as you showed the example the GR date and Static delivery Date are different and i want to calculate it on the basis of this two days only. 

BR

Yashh

[Ahmedx]

Measure = 
VAR _Days = DATEDIFF('table'[GR date],'table'[Static Delivery date],DAY)
RETURN
SWITCH(_Days,0, 1,1,0.80,2,0.6,3,0.4,4,0.2,0.01)