Forum Discussion
Challenge
I have two columns, the entry date of a product, and the leave date of a product. In another table i have a dimension table of days. I need to select a date in dimension table of days(as a filter),...
Hi Vitore ,
Would you please show us your expected output? I don't understand "OR if lower than leave date, use the leave date to calculate." well.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
I need to see how many days the item was in stock that month by the date i use was input, that is the diference of days the item enter the stock until the day I input. However, this item could be out stock earlier than the day I use as input, than the function need first verify the leave date of product is less than the input date. If less use the leave date, if superior use the input date. The output is the sum of diference of days.