First of all…i have to say you doing a really great job.
The Case: I have list of 20 stores which opened on various dates starting from 2005, in various countries. I am preparing the financial reports in power bi for the period 2017 and 2018. My datetable is set for the 2017-18 period.
I am trying to compute the sales per square feet for is 2017 & 2018 by country/store. However, i am unable to get the cumulative logic on the outlet area correctly [since the opening dates are outside the scope of the datetable, i have not created a relationship between opening dates and datetable ]
the relevant data is in two tables as follows:
i.) Outlet area table showing Outlet name, Opening date and outlet area
ii.) Sales table with monthly sales from 2017 onwards, outlet name, country name