Matrix Visual: Combing Two Calculations and Fields Into Visual

I think the easiest way would be to create a calculation group with calculation items for each column, something like

Year - 2 =
VAR LastDateWithValues =
    CALCULATE ( MAX ( Sales[Date] ), REMOVEFILTERS () )
VAR Result =
    CALCULATE (
        SELECTEDMEASURE (),
        'Date'[Year]
            = YEAR ( LastDateWithValues - 2 ),
        REMOVEFILTERS ( 'Date' )
    )
RETURN
    Result

and 

Month - 2 =
VAR LastDateWithValues =
    CALCULATE ( MAX ( Sales[Date] ), REMOVEFILTERS () )
VAR RefDate =
    EOMONTH ( LastDateWithValues, -2 )
VAR DatesToUse =
    DATESINPERIOD ( 'Date'[Date], RefDate, -12, MONTH )
VAR Result =
    CALCULATE ( SELECTEDMEASURE (), DatesToUse )
RETURN
    Result

The key is to take the MAX of your fact table date column, not of 'Date'[Date].

You could also create a measure for the month name labels like

Label =
FORMAT ( MAX ( 'Date'[Date] ), "mmmm" )

Hi! You will likely be able to achieve this using pagination/Report Builder. It has less rigid formating than a matrix in Power BI due to its pixel perfect nature.

Hi asa70,

Thank you audreygerred,johnt75, for your insights.

If your primary requirement is to replicate the appearance and formatting of the table with grouped headers and custom spans as shown in your screenshot, then using a Paginated Report would be the more suitable choice for your scenario.

Thank you.

Hi asa70,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further

Thank you.