Forum Discussion
Vitore
5 years agoFrequent Visitor
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),...
v-deddai1-msft
5 years agoCommunity Support
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