Forum Discussion
locle90
Helper I
Helper ITotal Accumulated without data
Dear All, I have fomule to calculate the count of item with leadtime days 0-14.But some days we don't have the order then i need day 7,8,9 should show with data 79. Could you help to advice how i ...
As Lead time is 0-14 days, I made a raw table called OrderLeadTime just 15 rows with the numbers 0-14
Then I linked as a 1-* to your calculated column "Order Lead Time" in table LeadTime
xx cumul =
var c = max(OrderLeadTime[OLT_Raw])
var t = CALCULATE(DISTINCTCOUNT(Leadtime[Item]),REMOVEFILTERS(OrderLeadTime[OLT_Raw]))
var td = CALCULATE(DISTINCTCOUNT(Leadtime[Item]),OrderLeadTime[OLT_Raw]<=c)
return divide(td,t,1)
PurpleGate
Resolver III
Resolver IIIAs Lead time is 0-14 days, I made a raw table called OrderLeadTime just 15 rows with the numbers 0-14
Then I linked as a 1-* to your calculated column "Order Lead Time" in table LeadTime
xx cumul =
var c = max(OrderLeadTime[OLT_Raw])
var t = CALCULATE(DISTINCTCOUNT(Leadtime[Item]),REMOVEFILTERS(OrderLeadTime[OLT_Raw]))
var td = CALCULATE(DISTINCTCOUNT(Leadtime[Item]),OrderLeadTime[OLT_Raw]<=c)
return divide(td,t,1)