Deferred Revenue - Using Colum Headers in a filter

Hi Anonymous ,

I suggest you to create an unrelated Calendar table first ,then create a measure and show your result in a matrix.

Calendar =
ADDCOLUMNS (
    CALENDARAUTO (),
    "YearMonth",
        YEAR ( [Date] ) * 100
            + MONTH ( [Date] ),
    "YearMonthName", FORMAT ( [Date], "MMM-YYYY" ),
    "MonthStart", EOMONTH ( [Date], -1 ) + 1
)

Measure:

Measure
    =
    VAR _GENERATE =
        GENERATE (
            VALUES ( 'Table'[Account] ),
            SUMMARIZE ( 'Calendar', 'Calendar'[YearMonthName], 'Calendar'[MonthStart] )
        )
    VAR _ADDSUM =
        ADDCOLUMNS (
            _GENERATE,
            "Sum",
                SUMX (
                    FILTER (
                        'Table',
                        'Table'[Account] = EARLIER ( [Account] )
                            && 'Table'[Start] <= EARLIER ( [MonthStart] )
                            && 'Table'[End] > EARLIER ( [MonthStart] )
                    ),
                    'Table'[Monthly]
                )
        )
    RETURN
        SUMX ( _ADDSUM, [Sum] )

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.