I am struggeling with a topic. I have this model, which has a ‘Date Table’ and an ‘Item Table’. Both filtering the ‘Invoiced Transactions’ Table. The ‘Date Table’ has a relationship to the ‘Invoiced Transactions’ between the columns ‘Date’ and ‘Sales Date’ and the Item Table has a relationship to the ‘Invoiced Transactions’ table between the columns ‘Item’ and ‘Item’. I can’t change the relationships.
And I want to calculate the Sales after the product release date. I want to set the Product Release Date as beginning date value for the calculation of the Revenue past 3 month. So that I get the correct revenue after release.