Calculate Cumulative total from December to December. Example, From Dec'2020 to Dec'2021 Cumulative

Hi,

I tried to create a sample pbix file like below, and please check the below picture and the attached pbix file.

YTD and previous December: =
IF (
    NOT ISBLANK ( [Amount measure:] ) && HASONEVALUE ( 'Calendar'[Date] ),
    CALCULATE ( [Amount measure:], DATESYTD ( 'Calendar'[Date] ) )
        + CALCULATE (
            [Amount measure:],
            FILTER (
                ALL ( 'Calendar' ),
                'Calendar'[Year]
                    = MAX ( 'Calendar'[Year] ) - 1
                    && 'Calendar'[Month number] = 12
            )
        )
)

Hi,

Thank you for your feedback.

The measure has HASONEVALUE(Calendar[Date]) function as a condition. This condition is not to show the total row (when it has more than one date value) in the table visualization.

If you write a measure without HASONEVALUE, it will show as expected.

YTD and previous December: = 
IF (
    NOT ISBLANK ( [Amount measure:] ),
    CALCULATE ( [Amount measure:], DATESYTD ( 'Calendar'[Date] ) )
        + CALCULATE (
            [Amount measure:],
            FILTER (
                ALL ( 'Calendar' ),
                'Calendar'[Year]
                    = MAX ( 'Calendar'[Year] ) - 1
                    && 'Calendar'[Month number] = 12
            )
        )
)