Subscription data - Revenue and Active Subscribers calculations

Hi  soniajs ,

Create 3 measures as below:

MTD =
VAR _tab =
    CALCULATETABLE (
        VALUES ( 'Date'[Date] ),
        FILTER (
            ALL ( 'Date' ),
            'Date'[Month] = SELECTEDVALUE ( 'Date'[Month] )
                && YEAR ( 'Date'[Date] ) = YEAR ( MAX ( 'Date'[Date] ) )
        )
    )
RETURN
    CALCULATE (
        SUM ( 'Table'[Subscription Price (Monthly)] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Subscription Start Date] <= MAXX ( _tab, [Date] )
                && (
                    'Table'[Subscription End Date] >= MINX ( _tab, [Date] )
                        || 'Table'[Subscription End Date] = BLANK ()
                )
                && 'Table'[Email] = MAX ( 'Table'[Email] )
        )
    )

QTD =
VAR _tab =
    CALCULATETABLE (
        VALUES ( 'Date'[Date] ),
        FILTER (
            ALL ( 'Date' ),
            'Date'[Quarter] = SELECTEDVALUE ( 'Date'[Quarter] )
                && YEAR ( 'Date'[Date] ) = YEAR ( MAX ( 'Date'[Date] ) )
        )
    )
RETURN
    CALCULATE (
        SUM ( 'Table'[Subscription Price (Monthly)] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Subscription Start Date] <= MAXX ( _tab, [Date] )
                && (
                    'Table'[Subscription End Date] >= MINX ( _tab, [Date] )
                        || 'Table'[Subscription End Date] = BLANK ()
                )
                && 'Table'[Email] = MAX ( 'Table'[Email] )
        )
    )

YTD =
VAR _tab =
    CALCULATETABLE (
        VALUES ( 'Date'[Date] ),
        FILTER ( ALL ( 'Date' ), YEAR ( 'Date'[Date] ) = YEAR ( MAX ( 'Date'[Date] ) ) )
    )
RETURN
    CALCULATE (
        SUM ( 'Table'[Subscription Price (Monthly)] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Subscription Start Date] <= MAXX ( _tab, [Date] )
                && (
                    'Table'[Subscription End Date] >= MINX ( _tab, [Date] )
                        || 'Table'[Subscription End Date] = BLANK ()
                )
                && 'Table'[Email] = MAX ( 'Table'[Email] )
        )
    )

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!