This content has been marked as final. Show 3 replies
Can you define date range for period 1?
Sure - period 1 would be 6/5/2016 - 7/2/2016. Thanks!
- I think your sample is missing keys and you can only join it now on dates/periods which makes my effort somewhat pointless
- Since forecast table periods are longer than 1 period you must use dates range when joining (>= and < or 'between' operators) which cannot be done with blending or standard excel join interface
- I have attached a wb with a legacy excel connection with custom join and your excel file with another table in it with the same join (I named your table 'revenue' and 'forecast')