Semi-additive max date

Hi,

I have used Alberto and Marcos DAX pattern for Semi-additive calculations

Semi-additive calculations – DAX Patterns
Primaraly the DAX code to calculate Balance per customer.

I need to add complexity but dont really know how.

I would like to add Product and another date column: EndDate. (The last date the customer can use that product).

I would now like to find the last Balance[Date] for each Product per customer. And from that list find the last EndDate for the Customer.
From that information would I then need to calculate how many customers with an EndDate in that particular month.

Thats my goal: Lost Customers per month

Can i nestle another calculatetable in the first one?

Do I repeat the first variables with EndDate instead?

Is it possible to solve in the filter section of the Calculate(Max()?

Example from Alberto and Marcos:    

Balance LastDateByCustomer :=
VAR MaxBalanceDates =
    ADDCOLUMNS (
        SUMMARIZE (            -- Retrieves the customers
            Balances,          -- from the Balances table
            Customers[Name]
        ),
        "@MaxBalanceDate", CALCULATE (     -- Computes for each customer
            MAX ( Balances[Date] )         -- their last date 
        )
    )
VAR MaxBalanceDatesWithLineage =
    TREATAS (                  -- Changes the lineage of MaxBalanceDates
        MaxBalanceDates,       -- so to make it filter
        Customers[Name],       -- the customer name
        'Date'[Date]           -- and the date
    )
VAR Result =
    CALCULATE (
        SUM ( Balances[Balance] ),
        MaxBalanceDatesWithLineage
    )
RETURN
    Result

The EndDate can change so a later change can set the EndDate to earlier than before. It's therefore not possible to just look att max endDate.