I ve tried to use NewColumn and SUMX but it didn't work. (single value could not be determined) I also tried to merge it with Merge Queries but it didn't work neither. (dates were not sorted correctly)
Currently, there is a relationship between a Date table and Table 1 & 2. There is also a relationship between a table with Productnames and Table 1&2.