I don't 100% understand what your requirement is but taking a guess you don't want future calculations to include previous figures ?
Appreciate if you could try Analysis > uncheck Aggregate Measures.
If this doesn't solve your issue, can you please upload an example using dummy data and show the working for how you have gotten to the point you are stalling at.
just take normal example that there is a shopping mall with 10 units . so
in the current month 7 units are occupied and 3 are vacant. if anyone of
units contract date end by current month means 4 units are vacancy for
feature month but if any one of occupied tenant (unit) will continue their
contract (as agreed in advance) then have to exclude this unit from
vacancy (for feature)
On Thu, Jul 12, 2018 at 11:24 AM, Peter Fakan <firstname.lastname@example.org>