I've tried to create mock up data using your screenshot and blend it found the expected output. See this
Only difference is I don't have any filter in this view though you've Date field in filters shelf. Put your filter on context and check if this fix your issue else you can use join instead of blending. If you can provide some sample mock up of your data sources in excel then we can help you to resolve the issue.
Book1_v10.2.twbx 29.8 KB