Trend from History Table v2.0

Good afternoon Community,

In 2017 v-chuncz-msft provided this solution to creating a history table:

https://community.powerbi.com/t5/Desktop/Trend-from-History-Table/m-p/200304/highlight/true#M88115

Today I need help expanding that solution to support one additional column in the source data.

Table Structure:

Customer ID (int) | Subscribed From (date) | Subscribed Until (date) | Subscription Type (string)

I would like the resulting table to include a column for each distinct Subscription Type. I could achieve this by duplicating that portion of the ADDCOLUMNS argument manually for each Subscription Type, but I would prefer to have a dynamic solution.

I imagine this is a place where I would need the DISTINCT function, but I can't quite figure that out.

Table =
ADDCOLUMNS (
    CALENDARAUTO (),
    EachDistinctServiceType, CALCULATE (
        DISTINCTCOUNT ( Table1[Customer ID] ),
        FILTER (
            Table1,
            Table1[Subscribed From] <= [Date]
                && (
                    Table1[Subscribed Until] > [Date]
                        || ISBLANK ( Table1[Subscribed Until] )
                && Table1[Service Type] = "EachDistinctServiceType
                )
        )
    )
)

The resulting table should look like this: