In Power BI: I have a table with an ID, opening date and closing date for stores I then have a more updated table with just opening dates, and the same but for closings.

Let's call the tables: Stores, Openings, Closings.

I want to create measures for a matrix that for a single selected year shows me the following: Active, Openings, Closings, Total.

The basemeasure of Active is the count of all active stores from "Stores" table, but I don't want to consider the closing dates for the selected year. This measure works fine.

However, we will need another version of Active which we will use in the matrix, as explained later.

Total is just Active + Openings + Closings (+ because I show the closings as negative).

Now, regarding Active, we need the active to carry over the numbers from openings & closings onto the next month, and the same with the total ofc.

Example of expected result: