Forum Discussion
measure delivery on time in variable time zone
I want to measure the quote for the delivery on time and for each customer. The borders, when a delivery is on time, are variable.
For example: All deliveries, who 3 days too early and 1 day too late, are ok.
Can someone help me with the problem?
5 Replies
- amitchandak
Super User
Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
My idea is to define 2 variables. but i don´t know how I should do it.
Here one step of my idea:
delivery loyalty quote =Var delivery_loyalty = CALCULATE(COUNTROWS('orders'),FILTER('orders',AND('orders'[days of delay]>= Lower_boundary, 'orders'[days of delay] <= Upper_boundary)))returndelivery_loyalty / [no. of orders]
