I have Delivery data which has a number of forecast dates. These forecasts do not occur over the weekend. I would like to return the initial, middle (D+7 always has a value, so I'll use this), and final forecast value for each Delivery date.
I took a look at the Excel file and screenshot you shared, but I'm not familiar enough with this type of data to be sure what end result you're looking for. If you could share a workbook (twbx) and say a little more about how what you've achieved is different from what you want, that could help us sort it out.