Dates and time intervals
I have a request from my sales team to implement a discount simulation in our sales analysis model.
To be more specific. I have a model with sales data by day/customer/product. In a different model account managers will input a discount rate by client and product with a validity date, meaning I will have a start date and an end date for a specific discount.
I need to make the link between the two models and find the corresponding discount to each sale based on the invoice date.
Here is an example of the structure of the models I have and the desired result.
I will be very greatful if someone can share an idea on how to impliment this.