Condition problem in a query with 2 subqueries

Hello, I come across a condition issue in PowerQuery. I receive daily an XLS file containing 2 tabs with the same structure: Tab 1: production history of the last 30 days, excluding produc...