Cumulative Total Goes Back Too Far

HI Roseventura ,

You can try to use following measure if it works on your side:

Cumulative Sales LY =
VAR LastSalesDate =
    CALCULATE (
        LASTDATE ( PBI_AEP_Shipments_Multi[Formatted Transaction Date] ),
        ALL ( PBI_AEP_Shipments_Multi )
    )
VAR _currDate =
    MAX ( PBI_FSCAPF[PADDATE] )
RETURN
    IF (
        SELECTEDVALUE ( PBI_FSCAPF[PADDATE] ) > LastSalesDate,
        BLANK (),
        IF (
            YEAR ( currDate ) > 2018,
            CALCULATE (
                [Sales LY],
                FILTER (
                    ALLSELECTED ( PBI_FSCAPF ),
                    PBI_FSCAPF[PADDATE] <= MAX ( PBI_FSCAPF[PADDATE] )
                )
            ),
            CALCULATE (
                [Sales LY],
                FILTER (
                    ALLSELECTED ( PBI_FSCAPF ),
                    PBI_FSCAPF[PADDATE] <= MAX ( PBI_FSCAPF[PADDATE] )
                        && YEAR ( PBI_FSCAPF[PADDATE] ) = YEAR ( currDate )
                )
            )
        )
    )

If above not help, can you please share some sample data for test? You can create some fake data upload to onedrive or google drive then share link here.

Notice: do mask on sensitive data.

Regards,

Xiaoxin Sheng