I have two tables, one for product demand, and one with product availability dates - how would I pull the date at which point a product will have a greater quantity available than demand, adding it to the Demand table? Thanks!
Is it based on Running Total demand? I think you would have to join the data based on product, then compare the demands and look up the date value.
I mocked up a draft, let me know what you think. This assumes it will look up the first date when there is enough availability. There is also 3 lines where the running total demand is higher than the availability. You could add those again using union tool.