Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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
I do not understand. you explain here what percentage will be, and why?
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
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)
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |