Hi everybody,
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.
While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!